[Pgpool-general] Online Recovery Question

A W angvaw at gmail.com
Wed Jun 15 20:03:58 UTC 2011


Hi everyone, I am new to this list. I am experimenting with Pgpool-II
for high availability and load balancing purposes.

Regarding the online recovery caveat mentioned in the manual:

"Note that there is a restriction about online recovery. If pgpool-II
itself is installed on multiple hosts, online recovery does not work
correctly, because pgpool-II has to stop all clients during the 2nd
stage of online recovery. If there are several pgpool hosts, only one
will have received the online recovery command and will block
connections."

What should be the course of action if I run multiple pgpool-II
instances, and I need to recover a database? For example, let my
environment consist of multiple, redundant application servers, each
with its own pgpool. Attached to each pgpool is the same set of
Postgres clusters, of course. My guess would be to perform the
following steps:

1) Shut down all pgpool/app server pairs except for one (thus, for a
small period of time, all connections will go through the one remaning
pgpool/app server - this is fine for me)
2) Perform online recovery on the remaining pgpool
3) Start up all the previously-shutdown pgpools/app servers.

I appreciate your input. Thank you.
AW


More information about the Pgpool-general mailing list