2011/7/22 Fujii Masao <masao.fujii@xxxxxxxxx>: > On Fri, Jul 22, 2011 at 1:29 AM, A J <s5aly@xxxxxxxxx> 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@xxxxxxxxxxxxxx) > 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
