[Pgpool-general] Can a failed master rejoin as a slave?
    Matt Solnit 
    msolnit at soasta.com
       
    Fri Jun 17 04:49:40 UTC 2011
    
    
  
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.
    
    
More information about the Pgpool-general
mailing list