[pgpool-general: 2743] Re: How pgpool identifies Master/Salve!

Yugo Nagata nagata at sraoss.co.jp
Thu Apr 10 15:59:29 JST 2014


In master slave mode with streaming-replication, pgpool issues 
"SELECT pg_is_in_recovery()" to backends in order of backend_hostname_ID
until to find a PostgreSQL returning FALSE, which pgpool regards as the
primary, and others are all regarded as slaves.

On Thu, 10 Apr 2014 09:05:53 +0530
Abhilash MB <abhilash.mb at poornam.com> wrote:

> Hey dear guys,
> Can anyone tell me how pgpool identifies current Master/ Slave server 
> after each restart ? I have done some experiments by swapping 
> backend_hostname0 and backend_hostname1 in pgpool.conf and once I 
> restarted pgpool service it took 'backend_hostname0' as Master!. Can 
> anyone please shed some light on this issue ?
> Thank you,
> Abhilash
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general

Yugo Nagata <nagata at sraoss.co.jp>

More information about the pgpool-general mailing list