[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.pgpool.net/pipermail/pgpool-general/attachments/20130722/ed0c54c1/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sean.vcf
Type: text/x-vcard
Size: 275 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20130722/ed0c54c1/attachment.vcf>
More information about the pgpool-general
mailing list