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

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


Hi,

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?

Thanks,
Sean
-------------- 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