pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedFollowup on 'Standby promotion does not work'
4+ messages / 4 participants
[nested] [flat]
* Followup on 'Standby promotion does not work'
@ 2011-07-21 16:29 A J <s5aly@yahoo.com>
2011-07-22 13:29 ` Re: Followup on 'Standby promotion does not work' Fujii Masao <masao.fujii@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: A J @ 2011-07-21 16:29 UTC (permalink / raw)
To: pgsql-admin
Couple of months back, Josh Berkus posted an issue with promotion of the standby in Streaming replication. Subject 'Standby promotion does not work' in the pgsql-hackers forum.
It seemed that during failover, it was not possible to repoint the rest of the slaves to the new master. Is this resolved ?
Thanks.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Followup on 'Standby promotion does not work'
2011-07-21 16:29 Followup on 'Standby promotion does not work' A J <s5aly@yahoo.com>
@ 2011-07-22 13:29 ` Fujii Masao <masao.fujii@gmail.com>
2011-07-22 14:14 ` Re: Followup on 'Standby promotion does not work' Kevin Grittner <Kevin.Grittner@wicourts.gov>
2011-07-22 15:49 ` Re: Followup on 'Standby promotion does not work' Cédric Villemain <cedric.villemain.debian@gmail.com>
0 siblings, 2 replies; 4+ messages in thread
From: Fujii Masao @ 2011-07-22 13:29 UTC (permalink / raw)
To: A J <s5aly@yahoo.com>; +Cc: pgsql-admin
On Fri, Jul 22, 2011 at 1:29 AM, A J <s5aly@yahoo.com> wrote:
> Couple of months back, Josh Berkus posted an issue with promotion of the
> standby in Streaming replication. Subject 'Standby promotion does not work'
> in the pgsql-hackers forum.
I could not find that thread.
> It seemed that during failover, it was not possible to repoint the rest of
> the slaves to the new master. Is this resolved ?
No.
When failover happens, basically you still need to take a fresh base backup from
new master, copy it to the rest of standbys, change their primary_conninfo so
that it points to new master, and restart them. But, if you always
assign the same
IP address to the master server by using virtual IP technique, you
would not need
to change primary_conninfo.
Regards,
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Followup on 'Standby promotion does not work'
2011-07-21 16:29 Followup on 'Standby promotion does not work' A J <s5aly@yahoo.com>
2011-07-22 13:29 ` Re: Followup on 'Standby promotion does not work' Fujii Masao <masao.fujii@gmail.com>
@ 2011-07-22 14:14 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
1 sibling, 0 replies; 4+ messages in thread
From: Kevin Grittner @ 2011-07-22 14:14 UTC (permalink / raw)
To: Fujii Masao <masao.fujii@gmail.com>; A J <s5aly@yahoo.com>; +Cc: pgsql-admin
Fujii Masao <masao.fujii@gmail.com> wrote:
> On Fri, Jul 22, 2011 at 1:29 AM, A J <s5aly@yahoo.com> wrote:
>> Couple of months back, Josh Berkus posted an issue with promotion
>> of the standby in Streaming replication. Subject 'Standby
>> promotion does not work' in the pgsql-hackers forum.
>
> I could not find that thread.
http://archives.postgresql.org/pgsql-hackers/2011-04/msg00607.php
-Kevin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Followup on 'Standby promotion does not work'
2011-07-21 16:29 Followup on 'Standby promotion does not work' A J <s5aly@yahoo.com>
2011-07-22 13:29 ` Re: Followup on 'Standby promotion does not work' Fujii Masao <masao.fujii@gmail.com>
@ 2011-07-22 15:49 ` Cédric Villemain <cedric.villemain.debian@gmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: Cédric Villemain @ 2011-07-22 15:49 UTC (permalink / raw)
To: Fujii Masao <masao.fujii@gmail.com>; +Cc: A J <s5aly@yahoo.com>; pgsql-admin
2011/7/22 Fujii Masao <masao.fujii@gmail.com>:
> On Fri, Jul 22, 2011 at 1:29 AM, A J <s5aly@yahoo.com> wrote:
>> Couple of months back, Josh Berkus posted an issue with promotion of the
>> standby in Streaming replication. Subject 'Standby promotion does not work'
>> in the pgsql-hackers forum.
>
> I could not find that thread.
>
>> It seemed that during failover, it was not possible to repoint the rest of
>> the slaves to the new master. Is this resolved ?
>
> No.
>
> When failover happens, basically you still need to take a fresh base backup from
> new master, copy it to the rest of standbys, change their primary_conninfo so
> that it points to new master, and restart them. But, if you always
> assign the same
> IP address to the master server by using virtual IP technique, you
> would not need
> to change primary_conninfo.
repmgr allows that, we can reaffect a Standby to a new Primary with
the command (it will find the new master and switch to it) : 'repmgr
-f /etc/repmgr/repmgr.conf standby follow'
>
> Regards,
>
> --
> Fujii Masao
> NIPPON TELEGRAPH AND TELEPHONE CORPORATION
> NTT Open Source Software Center
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
--
Cédric Villemain +33 (0)6 20 30 22 52
http://2ndQuadrant.fr/
PostgreSQL: Support 24x7 - Développement, Expertise et Formation
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2011-07-22 15:49 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-07-21 16:29 Followup on 'Standby promotion does not work' A J <s5aly@yahoo.com>
2011-07-22 13:29 ` Fujii Masao <masao.fujii@gmail.com>
2011-07-22 14:14 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2011-07-22 15:49 ` Cédric Villemain <cedric.villemain.debian@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox