[pgpool-general: 8396] Re: Determine primary frontend

[Jon SCHEWE]

Umar,

Thank you. That's exactly what I need.


Jon Schewe

Principal Software Systems Technologist

C: +1 612.263.2718

O: +1 952.545.5720

jon.schewe at raytheon.com

Raytheon BBN

Raytheon Intelligence & Space

5775 Wayzata Blvd. Suite 630

St. Louis Park, MN 55416


RTX.com<https://www.rtx.com/> | LinkedIn<https://www.linkedin.com/company/raytheontechnologies> | Twitter<https://twitter.com/raytheontech> | Instagram<https://www.instagram.com/raytheontechnologies>

________________________________
From: Umar Hayat <m.umarkiani at gmail.com>
Sent: Monday, September 12, 2022 19:34
To: Jon SCHEWE <jon.schewe at raytheon.com>
Cc: pgpool-general at pgpool.net <pgpool-general at pgpool.net>
Subject: [External] Re: [pgpool-general: 8386] Determine primary frontend

Hi Jon,
Leader watchdog node holds the VIP, try pcp_watchdog_info<https://www.pgpool.net/docs/latest/en/html/pcp-watchdog-info.html> to get current leader host information.

Regards
Umar Hayat
Bitnine Inc<http://bitnine.net>

On Tue, Sep 13, 2022 at 7:33 AM Jon SCHEWE <jon.schewe at raytheon.com<mailto:jon.schewe at raytheon.com>> wrote:
Is there a way to query pgpool to determine which host is the primary frontend? Or is the only way to determine this to check the IP addresses on all potential frontends to see which one has the virtual IP?

Jon
_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net<mailto:pgpool-general at pgpool.net>
http://www.pgpool.net/mailman/listinfo/pgpool-general
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20220913/b0b37cf8/attachment.htm>