---
name: "PGPOOL_SET"
section: "1"
platform: "linux"
package: "pgpool2"
version: "4.6.1-2"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/PGPOOL_SET"
---

# PGPOOL\_SET(1)

change a configuration parameter

## 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**\[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.

## 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\_RESET**(1)](/PGPOOL_RESET/1.md)), PGPOOL SHOW ([**PGPOOL\_SHOW**(1)](/PGPOOL_SHOW/1.md))

## NOTES

- 1\.

      **SET**

  https://www.postgresql.org/docs/current/static/sql-set.html