Re: Refactoring standby mode logic

From: Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
To: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: Refactoring standby mode logic
Date: 2012-12-03 13:53:50
Message-ID: m2ip8j44y9.fsf@2ndQuadrant.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> writes:
>> I'm not understanding the sequence difference well enough to comment
>> here, but I think some people are currently playing tricks in their
>> failover scripts with moving files directly to the pg_xlog of the server
>> to be promoted.
>
> That's still perfectly ok. It's only if you have a diverged timeline
> history, and you have files from one timeline in the archive and files from
> another in pg_xlog that you'll see a difference. But in such a split
> situation, it's quite arbitrary which timeline recovery will follow anyway,
> I don't think anyone can sanely rely on either behavior.

Fair enough.

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit kapila 2012-12-03 13:56:02 Re: Review: Patch to compute Max LSN of Data Pages
Previous Message Heikki Linnakangas 2012-12-03 13:35:54 Re: Switching timeline over streaming replication