[pgpool-general: 3534] Re: Find current PGpool master node

James Sewell james.sewell at lisasoft.com
Tue Mar 17 09:58:55 JST 2015


I want to know which one is master as we are having network issues and I'm
monitoring packets between the databases and the master server.

My assumption was that only the master polls the database nodes - but maybe
this is incorrect?


James Sewell,
PostgreSQL Team Lead / Solutions Architect

 Level 2, 50 Queen St, Melbourne VIC 3000

*P *(+61) 3 8370 8000  *W* www.lisasoft.com  *F *(+61) 3 8370 8099

On Tue, Mar 17, 2015 at 11:53 AM, Tatsuo Ishii <ishii at postgresql.org> wrote:

> > Hello all,
> >
> > Is there a command (show or pcp?) to find the current PGpool master node?
> >
> > I am using 3.3.1 (about to upgrade) with two PGpool nodes running active
> /
> > active behind an AWS ELB load balancer.
> >
> > I am not using a VIP, instead relying on the ELB to see that a PGpool has
> > gone down and take it out of the load a balancing group.
> Just out of the curiosity, why do you want to know which one is master?
> Also I'm interested in your set up because pgpool-II + AWS ELB load
> balancer configuration has some users and I would like to enhance
> pgpool-II to better serve with the configuration. I have not yet found
> the best practice of pgpool-II on AWS.
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp


The contents of this email are confidential and may be subject to legal or 
professional privilege and copyright. No representation is made that this 
email is free of viruses or other defects. If you have received this 
communication in error, you may not copy or distribute any part of it or 
otherwise disclose its contents to anyone. Please advise the sender of your 
incorrect receipt of this correspondence.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150317/e0523c08/attachment.html>

More information about the pgpool-general mailing list