Vertica Analytics Platform Version 10.0.x Documentation

ALTER ROUTING RULE

Changes an existing load balancing policy 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