PGPOOL_SET - change a configuration parameter
Contents
Description
The PGPOOLSET command changes the value of Pgpool-II configuration parameters for the current session.
This command is similar to the SET[1] command in PostgreSQL with an addition of PGPOOL keyword to
distinguish it from the PostgreSQL SET command. Many of the configuration parameters listed in Chapter 5,
Server Configuration, in the documentation can be changed on-the-fly with PGPOOLSET and it only affects
the value used by the current session.
Examples
Change the value of client_idle_limit parameter:
PGPOOL SET client_idle_limit = 350;
Reset the value of client_idle_limit parameter to default:
PGPOOL SET client_idle_limit TO DEFAULT;
Change the value of log_min_messages parameter:
PGPOOL SET log_min_messages TO INFO;
Name
PGPOOL_SET - change a configuration parameter
Notes
1.
SET
https://www.postgresql.org/docs/current/static/sql-set.html
pgpool-II 4.6.0 2023 PGPOOLSET(1)
See Also
PGPOOL RESET (PGPOOL_RESET(1)), PGPOOL SHOW (PGPOOL_SHOW(1))
Synopsis
PGPOOL SET configuration_parameter { TO | = } { value | 'value' | DEFAULT }
