[pgpool-general: 1258] Re: Master-slave mode with 2 primary servers problem

[Nozomi Anzai]

> Hi,
> 
> I have attached both files to this email. 
> I just edited the ips in pgpool.conf.

Thanks.

> I'm sure that /mnt/host_$new_master/ folders are accessible to pgpool and the failover script, and that I can touch the trigger files for both servers.

I confirmed your failover script worked without any problem.

Could you show us pgpool's log and each PostgreSQL's logs at that time,
too? 
And, what was the way you try to revert to the initial setup? Online
recovery, reinitting and starting the standby manually, and so on.


> Thank you for your time so far.
> 
> Regards,
> Stelios
> 
> -----Original Message-----
> From: pgpool-general-bounces ¡÷ pgpool.net [mailto:pgpool-general-bounces ¡÷ pgpool.net] On Behalf Of Nozomi Anzai
> Sent: 13 December 2012 01:38
> To: pgpool-general ¡÷ pgpool.net
> Subject: [pgpool-general: 1256] Re: Master-slave mode with 2 primary servers problem
> 
> > Hi everyone,
> > 
> > We have successfully installed a pgpool II setup with 2 postgres 
> > servers, one running as a primary and a second running as a slave.
> > While running some tests on the behaviour of our application during 
> > failover, we ended up having both servers running as primary ones.
> > We used the failover script to automate the procedure, and now we 
> > can't revert back to initial setup.
> > We're not sure what we need to do so the second server become slave 
> > again.
> 
> I think your pgpool.conf or failover command have something wrong.
> Could you show us them?
> 
> > Any help on that would be much appreciated.
> > 
> > Regards,
> > Stelios
> > 
> 
> 
> --
> Nozomi Anzai
> SRA OSS, Inc. Japan
> _______________________________________________
> pgpool-general mailing list
> pgpool-general ¡÷ pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general


-- 
Nozomi Anzai
SRA OSS, Inc. Japan