pgpool-II 4.1.1 Documentation
Prev | Up |  | Next

# 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

Prev | Home | Next
PGPOOL SHOW | Up | PGPOOL RESET