Re: The way to know whether the standby has caught up with the master
От | David Fetter |
---|---|
Тема | Re: The way to know whether the standby has caught up with the master |
Дата | |
Msg-id | 20110525180852.GA6735@fetter.org обсуждение исходный текст |
Ответ на | Re: The way to know whether the standby has caught up with the master (Simon Riggs <simon@2ndQuadrant.com>) |
Список | pgsql-hackers |
On Wed, May 25, 2011 at 12:34:59PM +0100, Simon Riggs wrote: > On Wed, May 25, 2011 at 6:16 AM, Heikki Linnakangas > <heikki.linnakangas@enterprisedb.com> wrote: > > >> To achieve that, I'm thinking to change walsender so that, when the > >> standby > >> has caught up with the master, it sends back the message indicating that > >> to > >> the standby. And I'm thinking to add new function (or view like > >> pg_stat_replication) > >> available on the standby, which shows that info. > > > > By the time the standby has received that message, it might not be caught-up > > anymore because new WAL might've been generated in the master already. > > AFAICS, this is an exact case of the Byzantine General's problem. Have they updated it to acknowledge that the city is now called Istanbul? Cheers, David. -- David Fetter <david@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate
В списке pgsql-hackers по дате отправления: