LOAD_BALANCE_GROUPS

Lists the objects contained by all load balance groups.

Lists the objects contained by all load balance groups. Each row in this table represents a single object that is a member of a load balance group. If a load balance group does not contain any objects, it appears once in this table with its type column set to 'Empty Group.'

Column Name Data Type Description
NAME VARCHAR The name of the load balance group
POLICY VARCHAR

The policy that sets how the group chooses the node for a connection. Contains one of the following:

  • ROUNDROBIN

  • RANDOM

  • NONE

FILTER VARCHAR The IP address range in CIDR format to select the members of a fault group that are included in the load balance group. This column only has a value if the TYPE column is 'Fault Group' or 'Subcluster.'
TYPE VARCHAR

The type of object contained in the load balance group. Contains one of:

  • Fault Group

  • Subcluster

  • Network Address Group

  • Empty Group

OBJECT_NAME VARCHAR The name of the fault group or network address included in the load balance group. This column is NULL if the group contains no objects.

Examples

=> SELECT * FROM LOAD_BALANCE_GROUPS;
     name      |   policy   |  filter   |         type          | object_name
---------------+------------+-----------+-----------------------+-------------
 group_1       | ROUNDROBIN |           | Network Address Group | node01
 group_1       | ROUNDROBIN |           | Network Address Group | node02
 group_2       | ROUNDROBIN |           | Empty Group           |
 group_all     | ROUNDROBIN |           | Network Address Group | node01
 group_all     | ROUNDROBIN |           | Network Address Group | node02
 group_all     | ROUNDROBIN |           | Network Address Group | node03
 group_fault_1 | RANDOM     | 0.0.0.0/0 | Fault Group           | fault_1
(7 rows)

See also