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