<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Hi all,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Sorry for the delay, it was not possible for me to answer before.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>To revert my setup, I just followed again step-by-step the instructions in <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><a href="http://www.postgresql.org/docs/9.1/static/warm-standby.html#PREPARING-MASTER-FOR-STANDBY">http://www.postgresql.org/docs/9.1/static/warm-standby.html#PREPARING-MASTER-FOR-STANDBY</a> and<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><a href="http://www.postgresql.org/docs/9.1/static/continuous-archiving.html#BACKUP-PITR-RECOVERY">http://www.postgresql.org/docs/9.1/static/continuous-archiving.html#BACKUP-PITR-RECOVERY</a><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Of course, I followed only the necessary steps and not all of them, and I used the backup from the proper database node.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Now I’ve got one primary and one standby server, just like before.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I think that Nozomi’s instructions are describing a similar procedure, although personally I didn’t have much success with it.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Thanks again.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Regards,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Stelios<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> pgpool-general-bounces@pgpool.net [mailto:pgpool-general-bounces@pgpool.net] <b>On Behalf Of </b>newbie my<br><b>Sent:</b> 26 December 2012 04:13<br><b>To:</b> Tatsuo Ishii<br><b>Cc:</b> pgpool-general@pgpool.net<br><b>Subject:</b> [pgpool-general: 1263] Re: Master-slave mode with 2 primary servers problem<o:p></o:p></span></p></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Yup I know.I'm asking this question to Stelios Limnaios.<o:p></o:p></p><div><p class=MsoNormal>Is the step that has been showed by Nozomi working or not?<o:p></o:p></p></div><div><p class=MsoNormal style='margin-bottom:12.0pt'>I want to verified the step with my setup but unfortunately my setup already have been deleted.<o:p></o:p></p><div><p class=MsoNormal>On Wed, Dec 26, 2012 at 9:59 AM, Tatsuo Ishii <<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>> wrote:<o:p></o:p></p><p class=MsoNormal>In my understanding, Nozomi has been waiting for response from Stelios Limnaios.<br>--<br>Tatsuo Ishii<br>SRA OSS, Inc. Japan<br>English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><o:p></o:p></p><div><div><p class=MsoNormal><br>> Hi,<br>> Sorry to interrupt. I'm also facing the same problem.<br>> Any progress with this?I'm curious to know whether this problem has been<br>> resolved or not.<br>><br>> On Thu, Dec 20, 2012 at 10:47 AM, Nozomi Anzai <<a href="mailto:anzai@sraoss.co.jp">anzai@sraoss.co.jp</a>> wrote:<br>><br>>> > 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<br>>> PGPool, to remove the second backend from configuration and add it back, to<br>>> 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>>> 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>>><br>>><br>>> > My main question is, how does PGPool know what server is running as a<br>>> primary?<br>>> > Is there a flag in configuration or maybe is there something related to<br>>> the Postgres server(s) that has been changed and I need to revert it back?<br>>><br>>> 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>>><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:<br>>> <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<br>>> 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<br>>> and the failover script, and that I can touch the trigger files for both<br>>> 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,<br>>> too?<br>>> > And, what was the way you try to revert to the initial setup? Online<br>>> 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>>><o:p></o:p></p></div></div></div><p class=MsoNormal><o:p> </o:p></p></div></div></body></html>