Creating Pgpool-II extensions v4

You must install and create the extensions in each database where you plan to use EDB Pgpool-II. To ensure all extensions are available for future databases, you can add the extension to the template1 database. Any extensions installed in the template1 database are created in each of the databases that uses template1 as a template during creation.

Pgpool_adm extension

Pgpool_adm is a set of extensions that allows SQL access to PCP commands. For information, see PCP commands.

After installing the Pgpool_adm extension, use the psql client application to connect to the database, and execute the following SQL command:


For more information about Pgpool_adm, see Pgpool_adm docs.

Pgpool_recovery extension

The Pgpool_recovery extension is required for online recovery and future fail-back mechanisms.

After installing the Pgpool_recovery extension, use psql to connect to the database. Create a Pgpool_recovery extension:

CREATE EXTENSION pgpool_recovery;

For more information about using the CREATE EXTENSION command, see the PostgreSQL core documentation.