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

Tatsuo Ishii ishii at postgresql.org
Thu May 15 21:54:49 JST 2014


> 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.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> I'm new to this software, so it's quite possible that I have misunderstood something ;)
> http://karlsbakk.net/tmp/pgpool-dbc1.conf
> http://karlsbakk.net/tmp/pgpool-dbc2.conf
> 
> Best regards and thanks for all help
> 
> 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.
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general


More information about the pgpool-general mailing list