Re: Followup on 'Standby promotion does not work'

2011/7/22 Fujii Masao <masao(dot)fujii(at)gmail(dot)com>:
> On Fri, Jul 22, 2011 at 1:29 AM, A J <s5aly(at)yahoo(dot)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(at)postgresql(dot)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