Re: Retrieve the snapshot's LSN - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Retrieve the snapshot's LSN
Date
Msg-id CA+Tgmoa286s8VrmoODaxPZRaTjXonKrd_tAouHqO4+LykcBe=A@mail.gmail.com
Whole thread Raw
In response to Re: Retrieve the snapshot's LSN  (Andres Freund <andres@anarazel.de>)
Responses Re: Retrieve the snapshot's LSN
List pgsql-hackers
On Thu, Jul 16, 2015 at 12:54 PM, Andres Freund <andres@anarazel.de> wrote:
> Well, in combination with logical decoding it kinda has one: It should
> allow you to take a dump of the database with a certain snapshot and
> replay all transactions with a commit lsn bigger than the "snapshot's
> lsn" and end up with a continually consistent database.
>
> Visibility for HS actually works precisely in commit LSN order, even if
> that is possibly different than on the primary...

That makes sense, and hopefully answers Florent's question about why
this is only exposed through the slot mechanism.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: RFC: replace pg_stat_activity.waiting with something more descriptive
Next
From: Robert Haas
Date:
Subject: Re: Support for N synchronous standby servers - take 2