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. 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
