View Issue Details

IDProjectCategoryView StatusLast Update
0000716Pgpool-IIGeneralpublic2022-06-28 11:24
Reportershyamsundarbaskaran Assigned To 
PriorityimmediateSeveritymajorReproducibilityN/A
Status closedResolutionopen 
PlatformUnixOSLinux, UbuntuOS Version16.04
Summary0000716: Master/Slave out of sync (pgpool2)
DescriptionHello Postgres Experts,
I have issue with my PostgreSQL environment.
Just for your note – Node 1 is Slave and Node 2 is Master
(Few months earlier Node 1 was Master, and Node 2 was slave)
While handing over this setup to me Node 1 is Slave and Node 2 is Master.
Node1 (Slave) is not even active now. (pgpool is up and running but postgres services are not coming up)
Node2 (Master) acts now as a standalone (with pgpool2 cluster)
I would like to make it sync between master/slave.
This cluster setup is managed by pgpool2
How to make Master and Slave in sync with this pgpool2 setup?
Any help would be much appreciated!!
TagsNo tags attached.

Activities

t-ishii

2021-05-28 11:51

developer   ~0003859

You can use pcp_recovery_node command.
https://www.pgpool.net/docs/latest/en/html/pcp-recovery-node.html

This forum is not for technical questions. Please subscribe pgpool-general to ask questions.
https://www.pgpool.net/mailman/listinfo/pgpool-general

shyamsundarbaskaran

2021-05-28 11:56

reporter   ~0003860

Hello t-ishii,

Thanks for your response.
I will check and get back

pengbo

2022-06-28 11:24

developer   ~0004076

No response over two weeks.
Close issue.

Issue History

Date Modified Username Field Change
2021-05-27 20:44 shyamsundarbaskaran New Issue
2021-05-28 11:51 t-ishii Note Added: 0003859
2021-05-28 11:56 shyamsundarbaskaran Note Added: 0003860
2021-06-01 13:01 administrator Status new => feedback
2022-06-28 11:24 pengbo Note Added: 0004076
2022-06-28 11:24 pengbo Status feedback => closed