[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