PGPOOL SET

Name

PGPOOL SET -- change a configuration parameter

Synopsis

   PGPOOL SET  configuration_parameter { TO | = } { value | 'value' | DEFAULT }
  

Description

The PGPOOL SET command changes the value of Pgpool-II configuration parameters for the current session. This command is similar to the SET 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 can be changed on-the-fly with PGPOOL SET 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;
    

See Also

PGPOOL RESET, PGPOOL SHOW