On 16.06.2011 00:06, Tatsuo Ishii wrote:
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.
Yes, these are exactly the steps you need.
Note that pgpool will have its status file, where it will remember the
state of the nodes (i.e. that one of the nodes is in state 3 - kicked).
Prior to starting pgpool, you will need to remove this file.
--
Tomasz Chmielewski
http://wpkg.org
_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
