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

Jon SCHEWE jon.schewe at raytheon.com
Tue Sep 13 23:03:40 JST 2022


Todd, this is showing the status of the backend nodes (postgresql), not the frontend nodes (pgpool).


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: Todd Stein <todd.stein at microfocus.com>
Sent: Monday, September 12, 2022 19:25
To: Jon SCHEWE <jon.schewe at raytheon.com>; pgpool-general at pgpool.net <pgpool-general at pgpool.net>
Subject: [External] Re: Determine primary frontend


This query will show the primary and standby nodes.

psql -h <VIP> -p 9999 -U pgpool postgres -c "show pool_nodes"









From: pgpool-general <pgpool-general-bounces at pgpool.net> on behalf of Jon SCHEWE <jon.schewe at raytheon.com>
Sent: Monday, September 12, 2022 6:33:04 PM
To: pgpool-general at pgpool.net <pgpool-general at pgpool.net>
Subject: [pgpool-general: 8386] Determine primary frontend



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
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/b93428d7/attachment.htm>


More information about the pgpool-general mailing list