PGPOOL_SET - change a configuration parameter
PGPOOL SET configuration_parameter { TO | = } { value | 'value' | DEFAULT }
The
PGPOOL SET 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
PGPOOL SET and it only affects the value
used by the current session.
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;
PGPOOL RESET (
PGPOOL_RESET(1)), PGPOOL SHOW (
PGPOOL_SHOW(1))
- 1.
-
SET