[Pgpool-general] Questions about online recovery
Ramon de Carvalho Valle
ramon at risesecurity.org
Sun Dec 20 01:46:36 UTC 2009
Hi,
I've a pgpool-II replication + load balance environment with seven
backend servers running PostgreSQL 8 and CentOS 5.
The backend 0 (master node) runs both pgpool-II and PostgreSQL. I'm
setting up online recovery with rsync using the same script for both 1st
and 2nd stage commands.
Considering a scenario where the backend 0 (which runs pgpool-II and
PostgreSQL) PostgreSQL is disconnected from pgpool-II, I have the
following questions:
* How online recovery is supposed to work in this case?
* Do I need to have pgpool-II installed on all backend servers? If so, I
will have dummy pgpool-II processes running on backend serves just to
have the pgpool communication manager running and be able to run
pcp_recovery_node from another backend?
* How 2nd stage of online recovery is supporsed to work if I am
recovering from a different backend than the one running pgpool-II and
PostgreSQL will continue accepting connections? Is cascading pgpool-II
connections to the backend servers a correct solution or workaround
here?
Best regards,
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20091219/c820f8fd/attachment.bin>
More information about the Pgpool-general
mailing list