Re: Followup on 'Standby promotion does not work'

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: A J <s5aly(at)yahoo(dot)com>
Cc: PG Admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Followup on 'Standby promotion does not work'
Date: 2011-07-22 13:29:58
Message-ID: CAHGQGwEgiqcd6CNNy+0Xa1xif9k=y2bVNrJyxFJD0ggtj+mqUQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bob Lunney 2011-07-22 14:14:09 Re: revoked permissions on table still allows users to see table's structure
Previous Message Juan Cuervo (Quality Telecom) 2011-07-22 13:24:23 Re: revoked permissions on table still allows users to see table's structure