ALTER ROUTING RULE
Syntax
ALTER ROUTING RULE rule_name { RENAME TO new_name | SET ROUTE TO 'cidr_range'| SET GROUP TO group_name }
Parameters
rule_name
|
The name of the existing routing rule to change. |
RENAME TO new_name
|
Changes the name of the routing rule to new_name. |
SET ROUTE TO 'cidr_range'
|
An IPv4 or IPv6 address range in CIDR format. Changes the address range of client connections this rule applies to. |
SET GROUP TO group_name
|
Changes the load balancing group that handles the connections that match this rule . |
Example
This example changes the routing rule named etl_rule so it uses the load balancing group named etl_rule to handle incoming connections in the IP address range of 10.20.100.0 to 10.20.100.255.
=> ALTER ROUTING RULE etl_rule SET GROUP TO etl_group; ALTER ROUTING RULE => ALTER ROUTING RULE etl_rule SET ROUTE TO '10.20.100.0/24'; ALTER ROUTING RULE => \x Expanded display is on. => SELECT * FROM routing_rules WHERE NAME = 'etl_rule'; -[ RECORD 1 ]----+--------------- name | etl_rule source_address | 10.20.100.0/24 destination_name | etl_group
See Also
- ALTER LOAD BALANCE GROUP
- ALTER NETWORK ADDRESS
- ALTER ROUTING RULE
- Connection Load Balancing Policies
- 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