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

[newbie my]

Yup I know.I'm asking this question to Stelios Limnaios.
Is the step that has been showed by Nozomi  working or not?
I want to verified the step with my setup but unfortunately my setup
already have been deleted.

On Wed, Dec 26, 2012 at 9:59 AM, Tatsuo Ishii <ishii at postgresql.org> wrote:

> In my understanding, Nozomi has been waiting for response from Stelios
> Limnaios.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>
> > Hi,
> > Sorry to interrupt. I'm also facing the same problem.
> > Any progress with this?I'm curious to know whether this problem has been
> > resolved or not.
> >
> > On Thu, Dec 20, 2012 at 10:47 AM, Nozomi Anzai <anzai at sraoss.co.jp>
> wrote:
> >
> >> > 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.
> >>
> >> Could you try the following steps to revert the initial setup?
> >> # You don't want the previous standby node to work as primary/master,
> and
> >> # now want to switch them, right?
> >>
> >> 1. Stop the previous primary node (it already stopped ?), and move
> $PGDATA
> >>    to another directory.
> >>
> >> 2. Do recovery of the previous primary node.
> >>    ex.)http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting/
> >>
> >>    2-1. Get base backup from a node which became primary by failover.
> >>    2-2. Copy the base backup to primary $PGDATA.
> >>    2-3. Put recovery.conf to primary $PGDATA and start.
> >>    2-4. Wait recoverying of primary until you see "streaming replication
> >>         successfully connected to primary" in the log.
> >>
> >> 3. Put trigger file and make the previous primary node primary without
> >>    recoverying again.
> >>
> >> 4. Do pcp_attach_node & pcp_promote_node and make this primary node is
> the
> >>    master node of pgpool.
> >>
> >> 5. Stop the previous master node, and do step 2 to make standby node.
> >>    And do pcp_attach_node to be as a slave node again.
> >>
> >>
> >> > 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?
> >>
> >> When pgpool tries find the new primary, which node is primary or standby
> >> is judged by each result of "SELECT pg_is_in_recovery()". If false, the
> >> node is primary.
> >>
> >> > 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
> >>
> >>
> >> --
> >> 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 HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20121226/01afa039/attachment.html>