Re: [HACKERS] Use of snapshot in logical replication

2017-06-07 Thread Andres Freund
On 2017-06-08 03:14:55 +0200, Petr Jelinek wrote: > On 08/06/17 03:08, Craig Ringer wrote: > > On 7 June 2017 at 18:16, sanyam jain wrote: > >> Hi, > >> > >> Can someone explain the usage of exporting snapshot when a logical > >> replication slot is created? > > > > It's

Re: [HACKERS] Use of snapshot in logical replication

2017-06-07 Thread Petr Jelinek
On 08/06/17 03:08, Craig Ringer wrote: > On 7 June 2017 at 18:16, sanyam jain 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 >

Re: [HACKERS] Use of snapshot in logical replication

2017-06-07 Thread Craig Ringer
On 7 June 2017 at 18:16, sanyam jain 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