Pgpool-II need function of
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
It is enough, if these function installed in template1 first. These
function do not needed that install in all databases.
This is required in all Pgpool-II installation.
$ cd pgpool-II-4.2.0/src/sql/pgpool-recovery $ make $ make install
$ psql template1 =# CREATE EXTENSION pgpool_recovery;
$ 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