network_interfaces

[iw84n01]

HI,

I'm still a novice when it comes this, anyway my problem is that I need to change the export_address of the server

here's the step:

CREATE SUBNET copy_subnet WITH '10.12.15.88';
CREATE NETWORK INTERFACE copy_node1 ON v_Dbdevv_node0001 with '10.12.15.11';
ALTER DATABASE Dbdevv EXPORT ON copy_subnet;
ALTER NODE v_Dbdevv_node0001 EXPORT ON copy_node1;

and i was able to change successfully

(select * from nodes | export_address IP was changed.


but then again, after double checking, the ip add was incorrect

so i tried to create a new subnet then use the same network interface "copy_node1"

because i want to know if vertica will prompt an error or not

then as expected i got this error

ROLLBACK 4043: Network Interface "copy_node1" already exists

now my question:

I was able to create a subnet but is there a query that i can check the created subnet and
the network interface ? other than using the v_monitor.network_interfaces ?






Regards,
Patrick

[id10t]

Hi!

[DELETED]

[iw84n01]

Hi!

Try next:

Code: Select all

select * from vs_subnets;

Daniel

Thanks Bro appreciate it ....

how about selecting the network interface created (not on this v_monitor.network_interfaces) ? =)

CREATE NETWORK INTERFACE ethXX on v_Dbidev_node0006 with '10.18.21.99';

ROLLBACK 4043: Network Interface "copy_node1" already exists

thanks again

[id10t]

Hi!

[DELETED]

[iw84n01]

try:

Code: Select all

select * from vs_network_interfaces;

Thanks So much ....
This is what I'm looking for ...