2.6. Installing pgpool_recovery

Pgpool-II need function of pgpool_recovery, pgpool_remote_start and pgpool_switch_xlog, when you use the online recovery that describes latter. Also pgpoolAdmin of management tool, stop, restart or reload a PostgreSQL on the screen by use pgpool_pgctl.

This is required in all Pgpool-II installation.

$ cd pgpool-II-4.7beta1/src/sql/pgpool-recovery
$ make
$ make install
   

After this, execute the following command to create the functions pgpool_recovery, pgpool_remote_start and pgpool_switch_xlog in the database specified in recovery_database (The default is 'postgres'). If a value other than the default is configured for recovery_database, replace "postgres" with the setting of recovery_database.

$ psql postgres
=# CREATE EXTENSION pgpool_recovery;
   

or

$ psql -f pgpool-recovery.sql postgres
   

With Pgpool-II 3.3 or later, you need to tweak postgresql.conf. Suppose the path to pg_ctl is /usr/local/pgsql/bin/pg_ctl. Then you add following to postgresql.conf.

pgpool.pg_ctl = '/usr/local/pgsql/bin/pg_ctl'
   

Probably you want to execute following after this:

$ pg_ctl reload -D /usr/local/pgsql/data