Download pgpool-II user manual

7.2 to 8.2
8.3 or later
ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT
ABORT; DISCARD ALL
"ABORT" is not issued when not in a transaction block for 7.4 or later.
You need to reload pgpool.conf upon modification of this directive.
Failover in the Connection Pool Mode
Failover in the connection pool mode is the same as in the raw mode.
back to top
Replication Mode
This mode enables data replication between the backends. The configuration parameters below must be set in addition
to everything above.
replication_mode
Setting to true enables replication mode. Default is false.
load_balance_mode
When set to true, SELECT queries will be distributed to each backend for load balancing. Default is false.
This parameter can only be set at server start.
replication_stop_on_mismatch
When set to true, if all backends don't return the same packet kind, the backends that differ from most
frequent result set are degenerated.
A typical use case is a SELECT statement being part of a transaction, replicate_select set to true, and SELECT
returning a different number of rows among backends. Non-SELECT statements might trigger this though.
For example, a backend succeeded in an UPDATE, while others failed. Note that pgpool does NOT examine
the content of records returned by SELECT.
If set to false, the session is terminated and the backends are not degenerated. Default is false.
failover_if_affected_tuples_mismatch V3.0 When set to true, if backends don't return the same number of affected tuples during an INSERT/UPDATE
/DELETE, the backends that differ from most frequent result set are degenerated. If the frequencies are