From: | Petr Jelinek <petr(at)2ndquadrant(dot)com> |
---|---|
To: | Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru> |
Cc: | Craig Ringer <craig(at)2ndquadrant(dot)com>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Logical Replication WIP |
Date: | 2016-08-25 08:22:59 |
Message-ID: | ad8f42d8-c0b4-5be7-314f-81dae1e9cf6a@2ndquadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
I found few bugs and missing docs and fixed those, here is updated
version of the patch.
No changes in terms of features.
On 20/08/16 19:24, Petr Jelinek wrote:
> Hi all,
>
> attaching updated version of the patch. Still very much WIP but it's
> slowly getting there.
>
> Changes since last time:
> - Mostly rewrote publication handling in pgoutput which brings a)
> ability to add FOR ALL TABLES publications, b) performs better (no need
> to syscache lookup for every change like before), c) does correct
> invalidation of publications on DDL
> - added FOR TABLE and FOR ALL TABLES clause to both CREATE PUBLICATION
> and ALTER PUBLICATION so that one can create publication directly with
> table list, the FOR TABLE in ALTER PUBLICATION behaves like SET
> operation (removes existing, adds new ones)
> - fixed several issues with initial table synchronization (most of which
> have been reported here)
> - added pg_stat_subscription monitoring view
> - updated docs to reflect all the changes, also removed the stuff that's
> only planned from the docs (there is copy of the planned stuff docs in
> the neighboring thread so no need to keep it in the patch)
> - added documentation improvements suggested by Steve Singer and removed
> the capitalization in the main doc
> - added pg_dump support
> - improved psql support (\drp+ shows list of tables)
> - added flags to COMMIT message in the protocol so that we can add 2PC
> support in the future
> - fixed DROP SUBSCRIPTION issues and added tests for it
>
> I decided to not deal with ACLs so far, assuming superuser/replication
> role for now. We can always make it less restrictive later by adding the
> grantable privileges.
>
--
Petr Jelinek http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
Attachment | Content-Type | Size |
---|---|---|
0001-Add-PUBLICATION-catalogs-and-DDL.patch.gz | application/gzip | 24.9 KB |
0002-Add-SUBSCRIPTION-catalog-and-DDL.patch.gz | application/gzip | 19.5 KB |
0003-Define-logical-replication-protocol-and-output-plugi.patch.gz | application/gzip | 12.9 KB |
0004-Make-libpqwalreceiver-reentrant.patch.gz | application/gzip | 7.4 KB |
0005-Add-logical-replication-workers.patch.gz | application/gzip | 33.4 KB |
0006-Logical-replication-support-for-initial-data-copy.patch.gz | application/gzip | 26.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Artur Zakirov | 2016-08-25 08:25:23 | Re: Bug in to_timestamp(). |
Previous Message | Ashutosh Bapat | 2016-08-25 07:15:34 | Re: Declarative partitioning - another take |