Installing pgpool_recovery

This is required in all Pgpool-II installation.

$ cd pgpool-II-x.x.x/src/sql/pgpool-recovery
$ make
$ make install
      

After this:

$ psql template1
=# CREATE EXTENSION pgpool_recovery;
      

or

$ psql -f pgpool-recovery.sql template1
      

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