-1

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?

Jae
  • 3
  • 3

1 Answers1

0

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.

Umar Hayat
  • 116
  • 4