NETWORK_ADDRESSES
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. |
Example
=> \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
- About Connection Load Balancing Policies
- ALTER LOAD BALANCE GROUP
- ALTER NETWORK ADDRESS
- ALTER ROUTING RULE
- CREATE LOAD BALANCE GROUP
- CREATE NETWORK ADDRESS
- CREATE ROUTING RULE
- DESCRIBE_LOAD_BALANCE_DECISION
- DROP LOAD BALANCE GROUP
- DROP NETWORK ADDRESS
- DROP ROUTING RULE
- LOAD_BALANCE_GROUPS
- NETWORK_ADDRESSES