Hi,<div>Sorry to interrupt. I'm also facing the same problem.</div><div>Any progress with this?I'm curious to know whether this problem has been resolved or not.<br><br><div class="gmail_quote">On Thu, Dec 20, 2012 at 10:47 AM, Nozomi Anzai <span dir="ltr"><<a href="mailto:anzai@sraoss.co.jp" target="_blank">anzai@sraoss.co.jp</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">> Hi,<br>
><br>
> I'm afraid I don't have the logs from the time of the problem.<br>
> What I have attached, is the logs from pgpool on startup.<br>
> There is nothing in Postgres logs when we stop/start pgpool.<br>
><br>
> 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.<br>
> I also did try to reset the recovery.conf files on both servers.<br>
> Finally, I tried to dump the pgpool_status file.<br>
<br>
</div>Could you try the following steps to revert the initial setup?<br>
# You don't want the previous standby node to work as primary/master, and<br>
# now want to switch them, right?<br>
<br>
1. Stop the previous primary node (it already stopped ?), and move $PGDATA<br>
to another directory.<br>
<br>
2. Do recovery of the previous primary node.<br>
ex.)<a href="http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting/" target="_blank">http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting/</a><br>
<br>
2-1. Get base backup from a node which became primary by failover.<br>
2-2. Copy the base backup to primary $PGDATA.<br>
2-3. Put recovery.conf to primary $PGDATA and start.<br>
2-4. Wait recoverying of primary until you see "streaming replication<br>
successfully connected to primary" in the log.<br>
<br>
3. Put trigger file and make the previous primary node primary without<br>
recoverying again.<br>
<br>
4. Do pcp_attach_node & pcp_promote_node and make this primary node is the<br>
master node of pgpool.<br>
<br>
5. Stop the previous master node, and do step 2 to make standby node.<br>
And do pcp_attach_node to be as a slave node again.<br>
<div class="im"><br>
<br>
> My main question is, how does PGPool know what server is running as a primary?<br>
> 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?<br>
<br>
</div>When pgpool tries find the new primary, which node is primary or standby<br>
is judged by each result of "SELECT pg_is_in_recovery()". If false, the<br>
node is primary.<br>
<div class="HOEnZb"><div class="h5"><br>
> Thanks again for your time and effort.<br>
><br>
> Regards,<br>
> Stelios<br>
><br>
><br>
> -----Original Message-----<br>
> From: <a href="mailto:pgpool-general-bounces@pgpool.net">pgpool-general-bounces@pgpool.net</a> [mailto:<a href="mailto:pgpool-general-bounces@pgpool.net">pgpool-general-bounces@pgpool.net</a>] On Behalf Of Nozomi Anzai<br>
> Sent: 18 December 2012 04:17<br>
> To: <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
> Subject: [pgpool-general: 1258] Re: Master-slave mode with 2 primary servers problem<br>
><br>
> > Hi,<br>
> ><br>
> > I have attached both files to this email.<br>
> > I just edited the ips in pgpool.conf.<br>
><br>
> Thanks.<br>
><br>
> > 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.<br>
><br>
> I confirmed your failover script worked without any problem.<br>
><br>
> Could you show us pgpool's log and each PostgreSQL's logs at that time, too?<br>
> And, what was the way you try to revert to the initial setup? Online recovery, reinitting and starting the standby manually, and so on.<br>
><br>
><br>
> > Thank you for your time so far.<br>
> ><br>
> > Regards,<br>
> > Stelios<br>
> ><br>
> > -----Original Message-----<br>
> > From: <a href="mailto:pgpool-general-bounces@pgpool.net">pgpool-general-bounces@pgpool.net</a><br>
> > [mailto:<a href="mailto:pgpool-general-bounces@pgpool.net">pgpool-general-bounces@pgpool.net</a>] On Behalf Of Nozomi Anzai<br>
> > Sent: 13 December 2012 01:38<br>
> > To: <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
> > Subject: [pgpool-general: 1256] Re: Master-slave mode with 2 primary<br>
> > servers problem<br>
> ><br>
> > > Hi everyone,<br>
> > ><br>
> > > We have successfully installed a pgpool II setup with 2 postgres<br>
> > > servers, one running as a primary and a second running as a slave.<br>
> > > While running some tests on the behaviour of our application during<br>
> > > failover, we ended up having both servers running as primary ones.<br>
> > > We used the failover script to automate the procedure, and now we<br>
> > > can't revert back to initial setup.<br>
> > > We're not sure what we need to do so the second server become slave<br>
> > > again.<br>
> ><br>
> > I think your pgpool.conf or failover command have something wrong.<br>
> > Could you show us them?<br>
> ><br>
> > > Any help on that would be much appreciated.<br>
> > ><br>
> > > Regards,<br>
> > > Stelios<br>
> > ><br>
> ><br>
> ><br>
> > --<br>
> > Nozomi Anzai<br>
> > SRA OSS, Inc. Japan<br>
> > _______________________________________________<br>
> > pgpool-general mailing list<br>
> > <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
> > <a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
><br>
><br>
> --<br>
> Nozomi Anzai<br>
> SRA OSS, Inc. Japan<br>
> _______________________________________________<br>
> pgpool-general mailing list<br>
> <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
> <a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br>
<br>
--<br>
Nozomi Anzai<br>
SRA OSS, Inc. Japan<br>
_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
</div></div></blockquote></div><br></div>