[pgpool-general: 3002] Re: Can backend0 be a slave ?

Muhammad Usama m.usama at gmail.com
Wed Jul 2 18:37:13 JST 2014


pgpool-II does not assumes backend0 to be a primary node by default. It
searches for the primary node at starts up time, and at primary node
failure. Can you please share some more details regarding which version of
pgpool-II you are using and also share the pgpool.conf and pgpool-II log

> I have 3 postgres nodes in streaming replication mode with two pgpools in
> active -stanby configuration.
> Is my observation right that pgpool always looks at backend0 as the master
> ? Supposing there is a failure in backend0 and backend1 is promoted as the
> new master. In this case if we are able to fix backend0 and attach it back
> as the slave of the new master (backend1), pgpool still assumes that
> backend0 is the master and tries to write to it. Is there a configuration
> setting to tell pgpool that backend0 is a slave and backend1 is a master ?

> Thanks in advance for your help.
> - Santosh
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140702/09e56878/attachment.html>

More information about the pgpool-general mailing list