NETWORK_ADDRESSES

Lists information about the network addresses defined in your database using the CREATE NETWORK ADDRESS statement.

Lists information about the network addresses defined in your database using the CREATE NETWORK ADDRESS statement.

Column Name Data Type Description
NAME VARCHAR The name of the network address.
NODE VARCHAR The name of the node that owns the network address.
ADDRESS VARCHAR The network address's IP address. This address can be either in IPv4 or IPv6 format.
PORT INT The network address's port number.
ADDRESS_FAMILY VARCHAR The format of the network address's IP address. This values is either 'ipv4' or 'ipv6'.
IS_ENABLED BOOLEAN Whether the network address is enabled. You can disable network addresses to prevent their use. If the address is disabled, the value in this column is False.
IS_AUTO_DETECTED BOOLEAN Whether Vertica created the network address automatically.

Examples

=> \x
Expanded display is on.

=> SELECT * FROM v_catalog.network_addresses;
-[ RECORD 1 ]----+-----------------
name             | node01
node             | v_vmart_node0001
address          | 10.20.100.247
port             | 5433
address_family   | ipv4
is_enabled       | t
is_auto_detected | f
-[ RECORD 2 ]----+-----------------
name             | node02
node             | v_vmart_node0002
address          | 10.20.100.248
port             | 5433
address_family   | ipv4
is_enabled       | t
is_auto_detected | f
-[ RECORD 3 ]----+-----------------
name             | node03
node             | v_vmart_node0003
address          | 10.20.100.249
port             | 5433
address_family   | ipv4
is_enabled       | t
is_auto_detected | f

See also