[Pgpool-general] Online Recovery Question

[Tomasz Chmielewski]

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