[Pgpool-general] Online Recovery Question

[Tatsuo Ishii]

>>> 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.

Or use -D option.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp