pgpool-II 4.7.2 Documentation
Prev | Up | Chapter 2. Installation of Pgpool-II | Next

# 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.7.2/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

Prev | Home | Next
Installing Pgpool-II | Up | Installing pgpool-regclass