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