pgpool-II 4.2.19 Documentation | |||
---|---|---|---|
Prev | Up | Chapter 2. Installation of Pgpool-II | Next |
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
.
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.19/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