From: | Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz> |
---|---|
To: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Petr Jelinek <petr(dot)jelinek(at)2ndquadrant(dot)com>, Craig Ringer <craig(at)2ndquadrant(dot)com> |
Cc: | Erik Rijkers <er(at)xs4all(dot)nl>, 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-23 23:14:25 |
Message-ID: | b1772c05-b761-1542-f8f8-42b5515cca06@catalyst.net.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 24/03/17 02:00, Peter Eisentraut wrote:
> On 3/21/17 21:38, Peter Eisentraut wrote:
>> This patch is looking pretty good to me, modulo the failing pg_dump tests.
>>
>> Attached is a fixup patch. I have mainly updated some comments and
>> variable naming for (my) clarity. No functional changes.
> Committed all that.
>
Testing now this patch is in, I'm unable to create a subscription:
(master)
bench=# CREATE PUBLICATION pgbench
FOR TABLE pgbench_accounts , pgbench_branches,
pgbench_tellers, pgbench_history
WITH (PUBLISH INSERT, PUBLISH UPDATE, PUBLISH DELETE);
(slave)
bench=# CREATE SUBSCRIPTION pgbench
CONNECTION 'port=5447 user=postgres dbname=bench'
PUBLICATION pgbench
WITH (COPY DATA);
ERROR: duplicate key value violates unique constraint
"pg_subscription_rel_srrelid_srsubid_index"
DETAIL: Key (srrelid, srsubid)=(0, 16389) already exists.
This is a pair of freshly initdb'ed instances, the master has a size 100
pgbench schema.
I'm guessing this is a different bug from the segfault also reported
regards
Mark
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Nasby | 2017-03-23 23:29:54 | Re: Privilege checks on array coercions |
Previous Message | Andrew Gierth | 2017-03-23 23:10:45 | Re: Hash support for grouping sets |