[pgpool-general: 1913] database recovery with a pgpool-II cluster

Sean Hogan sean at compusult.net
Tue Jul 23 02:44:28 JST 2013


http://www.pgpool.net/docs/latest/pgpool-en.html says this:

"While executing online recovery in replication mode, you need to stop 
all pgpool-II instances except the one which is doing online recovery. 
Otherwise DB can be running into inconsistent state."

I have a pair of clustered pgpool-II instances (and two PostgreSQL 
servers) using the watchdog and the latest code from git.  Does the 
above advice still apply?  I seem to recall someone saying the 
restriction would be relaxed in 3.3.

Also, with clustered pgpool-II instances it appears to be impossible to 
keep identical configuration files, because wd_hostname needs to be the 
external name of the host (as opposed to, say, "localhost"). Is that 
right?  Or is there some way for the configurations to be made identical?

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130722/ed0c54c1/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sean.vcf
Type: text/x-vcard
Size: 275 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130722/ed0c54c1/attachment.vcf>

More information about the pgpool-general mailing list