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

[Stelios Limnaios]

Hi,

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

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.

Thank you for your time so far.

Regards,
Stelios

-----Original Message-----
From: pgpool-general-bounces at pgpool.net [mailto:pgpool-general-bounces at pgpool.net] On Behalf Of Nozomi Anzai
Sent: 13 December 2012 01:38
To: pgpool-general at 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 at pgpool.net
http://www.pgpool.net/mailman/listinfo/pgpool-general
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf
Type: application/octet-stream
Size: 26095 bytes
Desc: pgpool.conf
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20121213/7d327cd0/attachment-0002.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: failover-stream.sh
Type: application/octet-stream
Size: 625 bytes
Desc: failover-stream.sh
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20121213/7d327cd0/attachment-0003.obj>