[Pgpool-general] How do I re-enable a replication node after it's been down?

Josh Berkus josh at agliodbs.com
Sat Aug 28 00:19:29 UTC 2010


1. I started pgpool
2. One of the two notes was down, so when I tried to connect to pgpool,
I got an error.
3. That node got marked status = 3.
4. I brought that PostgreSQL server up
5. I used pcp_add_node to change its status to 1
6. I ran some tests.
7. No queries were ever sent to that node.  All the queries were sent to
the other node.
8. I restarted pgpool.  Now my queries go to both nodes.

Based on the above, it seems like you can't make a replication node live
again without restarting pgpool.  Is this correct?

-- 
                                  -- Josh Berkus
                                     PostgreSQL Experts Inc.
                                     http://www.pgexperts.com


More information about the Pgpool-general mailing list