Yup I know.I'm asking this question to Stelios Limnaios.<div>Is the step that has been showed by Nozomi working or not?</div><div>I want to verified the step with my setup but unfortunately my setup already have been deleted.<br>
<br><div class="gmail_quote">On Wed, Dec 26, 2012 at 9:59 AM, Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
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><br>
<div class="HOEnZb"><div class="h5"><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>
>><br>
</div></div></blockquote></div><br></div>