You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
pgpool2 is running on 3 nodes with VIP. we are at latest pgpool2 4.5.5.1. postgresql is on 14.15.
Also we are running patroni for replicating data to another data center's postgres nodes.
now shutdown the pgpool services in any of the standby nodes.
pcp_watchdog_info shows that 3rd node is down
run show pool_nodes command connecting via psql with vip.
its showing all nodes are up
we trim the screenshot as we don't want to expose the IP and hostname.
Let me know if you need additional data.
The text was updated successfully, but these errors were encountered:
The word "standby" in pcp_watchdog_info means pgpool's standby, not PostgreSQL's streaming replication standby. On the other hand, "standby" in show pool_nodes means PostgreSQL's streaming replication standby. So unless the PostgreSQL's standby is running on the same host as the shutdowned pgpool, they look normal.
pgpool2 is running on 3 nodes with VIP. we are at latest pgpool2 4.5.5.1. postgresql is on 14.15.
Also we are running patroni for replicating data to another data center's postgres nodes.
now shutdown the pgpool services in any of the standby nodes.
pcp_watchdog_info shows that 3rd node is down
![image](https://private-user-images.githubusercontent.com/97266536/401593839-5688817b-522f-4bc1-add1-e4dd874e317e.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzkwNTYxNzEsIm5iZiI6MTczOTA1NTg3MSwicGF0aCI6Ii85NzI2NjUzNi80MDE1OTM4MzktNTY4ODgxN2ItNTIyZi00YmMxLWFkZDEtZTRkZDg3NGUzMTdlLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMDglMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjA4VDIzMDQzMVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTI4NzdlZmE5NjQxMWVmMjEyYjYwMDE5ZDY5NWNiZmQ2ZmQzMGU3MThiNTUyMzkwZTk2OTE3YzMxYzYxNTMxYmYmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.KptVe49c1VHnzE88NJujF8PTQ3CuDxDvTB-cLj1MNgY)
run show pool_nodes command connecting via psql with vip.
![image](https://private-user-images.githubusercontent.com/97266536/401593310-552aed38-138b-429f-a089-2b8458e35b00.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzkwNTYxNzEsIm5iZiI6MTczOTA1NTg3MSwicGF0aCI6Ii85NzI2NjUzNi80MDE1OTMzMTAtNTUyYWVkMzgtMTM4Yi00MjlmLWEwODktMmI4NDU4ZTM1YjAwLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMDglMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjA4VDIzMDQzMVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWRlODdkNzUyYTJjMWMwMDIxMDdiZmNlZTExZGRiMTcyNzAwMTE1MzNjYjE4MDY5MjRmN2VjNTc3ZTYyOGViYzYmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.DW1HI07NB1bYXBQsyshIjDlrFXBecrW5c1VPcZPlZ3w)
its showing all nodes are up
we trim the screenshot as we don't want to expose the IP and hostname.
Let me know if you need additional data.
The text was updated successfully, but these errors were encountered: