[pgpool-general: 4761] show pool_nodes returns different result when run on master and on slave

Avi Weinberg AviW at gilat.com
Tue Jul 5 23:02:07 JST 2016


Hi Experts,

I have one setup with one master and one slave.  For some reason the command psql -h 172.18.255.42 -U postgres   -p 9999 -t -c "show pool_nodes;" returns different result when it is running on the master or on the slave.
The 172.18.255.41 server shows status 2 when the query is run locally but when it is run on its partner it shows status 3.
What might have caused it.  How can I know which value is correct.


psql -h 172.18.255.42 -U postgres   -p 9999 -t -c "show pool_nodes;"

0       | 172.18.255.41 | 5432 | 3      | 0.500000  | standby | 0
1       | 172.18.255.42 | 5432 | 2      | 0.500000  | primary | 0


psql -h 172.18.255.41 -U postgres   -p 9999 -t -c "show pool_nodes;"
0       | 172.18.255.41 | 5432 | 2      | 0.500000  | standby | 0
1       | 172.18.255.42 | 5432 | 2      | 0.500000  | primary | 0

Thanks!
Avi
IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160705/c3e9ba22/attachment.html>


More information about the pgpool-general mailing list