Re: [HACKERS] Logical Replication WIP - Mailing list pgsql-hackers

From Erik Rijkers
Subject Re: [HACKERS] Logical Replication WIP
Date
Msg-id b6b39a46221710e395626ba34740549e@xs4all.nl
Whole thread Raw
In response to Re: [HACKERS] Logical Replication WIP  (Petr Jelinek <petr.jelinek@2ndquadrant.com>)
Responses Re: [HACKERS] Logical Replication WIP  (Petr Jelinek <petr.jelinek@2ndquadrant.com>)
List pgsql-hackers
On 2016-12-16 13:49, Petr Jelinek wrote:
> 
> version 13 of the patch.
> 
> 0001-Add-PUBLICATION-catalogs-and-DDL-v13.patch.gz (~32 KB)
> 0002-Add-SUBSCRIPTION-catalog-and-DDL-v13.patch.gz (~28 KB)
> 0003-Define-logical-rep...utput-plugi-v13.patch.gz (~13 KB)
> 0004-Add-logical-replication-workers-v13.patch.gz (~44 KB)
> 0005-Add-separate-synch...or-logical--v13.patch.gz (~2 KB)

Hi,

You wrote on 2016-08-05: :

> What's missing:
>  - sequences, I'd like to have them in 10.0 but I don't have good
>    way to implement it. PGLogical uses periodical syncing with some
>    buffer value but that's suboptimal. I would like to decode them
>    but that has proven to be complicated due to their sometimes
>    transactional sometimes nontransactional nature, so I probably
>    won't have time to do it within 10.0 by myself.

I ran into problems with sequences and I wonder if sequences-problems
are still expected, as the above seems to imply.

(short story: I tried to run pgbench across logical replication; and 
therefore
added a sequence to pgbench_history to give it a replica identity, and
cannot get it to work reliably ).


thanks,

Eik Rijkers








pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: [HACKERS] Crash on promotion when recovery.conf is renamed
Next
From: Michael Paquier
Date:
Subject: [HACKERS] Typos in waldender.c and slot.c