CREATE NETWORK INTERFACE
Identifies a network interface to which a node belongs.
This statement has been deprecated. Instead, use CREATE NETWORK ADDRESS.
Use this statement when you want to configure import/export operations from individual nodes to other Vertica clusters. By default, when you install Vertica, it creates interfaces for all connected networks. You would only need CREATE NETWORK INTERFACE in situations where the network topology has changed since you installed Vertica.
Syntax
CREATE NETWORK INTERFACE network‑interface‑name ON node‑name [WITH] 'node‑IP‑address' [PORT port_number] [ENABLED | DISABLED]
| network‑interface‑name |
The name you assign to the network interface, where network‑interface‑name conforms to conventions described in Identifiers. |
| node‑name |
The name of the node. |
| node‑IP‑address |
The node's IP address, either a public or private IP address. For more information, see Using Public and Private IP Networks. |
| PORT port_number | Sets the port number for the network interface. You must supply a network interface when altering the port number. |
| [ENABLE | DISABLE] | Enables or disables the network interface. |
Privileges
Superuser
Examples
Create a network interface:
=> CREATE NETWORK INTERFACE mynetwork ON v_vmart_node0001 WITH '123.4.5.6' PORT 456 ENABLED;