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

Nozomi Anzai anzai at sraoss.co.jp
Thu Dec 13 10:37:56 JST 2012

> 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

More information about the pgpool-general mailing list