Re: Logical replication existing data copy

From: Petr Jelinek <petr(dot)jelinek(at)2ndquadrant(dot)com>
To: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Erik Rijkers <er(at)xs4all(dot)nl>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, pgsql-hackers-owner(at)postgresql(dot)org
Subject: Re: Logical replication existing data copy
Date: 2017-03-10 16:33:59
Message-ID: d50b2b3b-a01d-93d8-0f73-34de9e710a0b@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 09/03/17 18:48, Peter Eisentraut wrote:
> On 3/6/17 05:27, Petr Jelinek wrote:
>> And lastly I changed the automagic around exporting, not exporting and
>> using the snapshot produced by CREATE_REPLICATION_SLOT into explicit
>> parameter for the CREATE_REPLICATION_SLOT command (and added simple
>> framework for adding more of those if needed in the future).
>
> It might be useful to make this into a separate patch, for clarity.
>

Okay here it is with this part split out. The first patch also help with
Craig's logical decoding on standby so it definitely makes sense to be
split.

This is also rebased on top of the position tracking fix [1] which
together with this patch fixes the error reported by Erik in his
previous email.

I think I resolved all your notes from the review. The only exception
being that the SQL queries are still in libpqwalreceiver.c as we first
need to agree on how the query interface would look like before moving
it around.

[1]
https://www.postgresql.org/message-id/b235fa69-147a-5e09-f8f3-3f780a1abb2e@2ndquadrant.com

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

Attachment Content-Type Size
0001-Add-option-to-control-snapshot-export-to-CREATE_REPL.patch binary/octet-stream 12.9 KB
0002-Logical-replication-support-for-initial-data-copy.patch binary/octet-stream 162.5 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2017-03-10 16:35:37 Re: GSOC Introduction / Eliminate O(N^2) scaling from rw-conflict tracking in serializable transactions
Previous Message Dagfinn Ilmari =?utf-8?Q?Manns=C3=A5ker?= 2017-03-10 16:29:32 Re: Need a builtin way to run all tests faster manner