'Install Pgpool on a server different from the DB server

I have 3 server (PgPool-II installed) and 2 Db (PostgreSQL installed) server.

I followed https://www.pgpool.net/docs/43/en/html/example-cluster.html

But can't execute psql template1 -c "CREATE EXTENSION pgpool_recovery"

What can i do?

Is it possible to install Postgresql and Pgpool on different servers in the first place?

postgresqlserverpsqlhigh-availabilitypgpool


Solution 1:[1]

You need to install Pgpool-II extension on the Postgresql machine to execute following command.

psql template1 -c "CREATE EXTENSION pgpool_recovery"

see details here: https://www.pgpool.net/docs/43/en/html/install-pgpool-recovery.html

And yes, its possible to have Pgpool-II and Postgresql on two different machines.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Umar Hayat

Related Questions