Hi everyone. I'm using pgpool-II with PostgreSQL 9.0 in streaming replication mode, and I'm able to get failover working correctly -- when the primary (master) goes down, the slave is promoted and everything is great. However, when I bring the primary back online using pcp_recovery_node, I find that pgpool-II immediately attempts to use it as a master again. This doesn't work, obviously, because it's no longer a master.
Should pgpool-II be able to support this? Ideally I could fail back and forth between the two nodes all day long, and pgpool-II would constantly know which is the master and which is the slave. Any help would be sincerely appreciated. I can provide configuration files, log files, etc. if needed. -- Matt P.S. The specific versions I'm using are pgpool-II 3.0.4 (built from source) and PostgreSQL 9.0.2, on 64-bit Linux. _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
