Re: Use of snapshot in logical replication

From: Craig Ringer <craig(at)2ndquadrant(dot)com>
To: sanyam jain <sanyamjain22(at)live(dot)in>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Use of snapshot in logical replication
Date: 2017-06-08 01:08:10
Message-ID: CAMsr+YEU1u48U6ZWOnEmAnJaSRSDguiPEr9q5W51rrtZm1wVoA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 7 June 2017 at 18:16, sanyam jain <sanyamjain22(at)live(dot)in> wrote:
> Hi,
>
> Can someone explain the usage of exporting snapshot when a logical
> replication slot is created?

It's used to pg_dump the schema at a consistent point in history where
all xacts are known to be in the snapshot (and thus dumped) or known
not to be (so they'll be streamed out on the slot).

See snapbuild.c etc.

--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Craig Ringer 2017-06-08 01:09:55 Re: tap tests on older branches fail if concurrency is used
Previous Message Petr Jelinek 2017-06-08 00:50:08 Re: logical replication - possible remaining problem