ALTER ROUTING RULE
Syntax
ALTER ROUTING RULE rule_name { RENAME TO new_name | SET ROUTE TO 'ip_addr'| 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 'ip_addr' | Changes the IP address range that this rule applies to. The ip_addr is the new range of incoming IP addresses in CIDR format. |
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
- 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