[pgpool-general: 2834] Re: Syncing databases after failure

[Tatsuo Ishii]

>> > Hi all
>> >
>> > Doing some testing here, I've setup a two-node cluster and checking
>> > if things work. Config is listed below and should speak for itself.
>> > What I can see is that things *seem* to work, but not quite. If I
>> > take down (poweroff or unplug) one of the node, it seems the changes
>> > done in the database on the now active node aren't replicated when
>> > the failed node is reconnected (or powered on).
>> 
>> It's an exepcted behaviro of pgpool-II. If a node is down for some
>> reason, pgpool-II disconnects it. You need to sync the down node by
>> using "online recovery" before reconnecting it.
> 
> Where can I find information on how to do online recovery?

Beisdes the pgpool-II manual, this is one of the good starting points:

http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/index.html

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Vennlige hilsener / Best regards
> 
> roy
> --
> Roy Sigurd Karlsbakk
> (+47) 98013356
> roy at karlsbakk.net
> http://blogg.karlsbakk.net/
> GPG Public key: http://karlsbakk.net/roysigurdkarlsbakk.pubkey.txt
> --
> I all pedagogikk er det essensielt at pensum presenteres intelligibelt. Det er et elementært imperativ for alle pedagoger å unngå eksessiv anvendelse av idiomer med xenotyp etymologi. I de fleste tilfeller eksisterer adekvate og relevante synonymer på norsk.