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

[Todd Stein]

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