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

[Stelios Limnaios]

Hi,

I'm afraid I don't have the logs from the time of the problem.
What I have attached, is the logs from pgpool on startup.
There is nothing in Postgres logs when we stop/start pgpool.

What I tried so far, was to restart the Postgres servers and then PGPool, to remove the second backend from configuration and add it back, to touch the trigger files.
I also did try to reset the recovery.conf files on both servers.
Finally, I tried to dump the pgpool_status file.

My main question is, how does PGPool know what server is running as a primary? 
Is there a flag in configuration or maybe is there something related to the Postgres server(s) that has been changed and I need to revert it back?

Thanks again for your time and effort.

Regards,
Stelios


-----Original Message-----
From: pgpool-general-bounces at pgpool.net [mailto:pgpool-general-bounces at pgpool.net] On Behalf Of Nozomi Anzai
Sent: 18 December 2012 04:17
To: pgpool-general at pgpool.net
Subject: [pgpool-general: 1258] Re: Master-slave mode with 2 primary servers problem

> 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 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


--
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 --------------
An embedded and charset-unspecified text was scrubbed...
Name: pgpool_startup.log.txt
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20121219/a6296e79/attachment.txt>