DOKK / manpages / debian 12 / pgpool2 / PGPOOL_SET.1.en
PGPOOL SET(1) pgpool-II 4.3.5 Documentation PGPOOL SET(1)

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
https://www.postgresql.org/docs/current/static/sql-set.html
2023 pgpool-II 4.3.5