From: | ning chan <ninchan8328(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | BDR PG9.4 Replica Identity Full |
Date: | 2018-01-05 03:57:25 |
Message-ID: | CAG0k5vD8u9WKR+fG=Treumr7-0Hdqg9eV48XsXiQr1dcyNeAHA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi BDR PostgreSQL experts,
I am recently trying out the logical decoding with Replica Identity Full
using postgresql-bdr94-server.
However, i seems to run in to a bug reporting in this thread
https://github.com/2ndQuadrant/bdr/issues/104.
I tested stock version of PG 9.4 and it works just fine.
Anyway know there is workaround or solution to get Replica Identity Full
working in postgresql-bdr?
To reproduce:
test1=# create table test (i int primary key, t text);
CREATE TABLE
test1=# alter table test replica identity full;
ALTER TABLE
test1=# insert into test values (1, 'hello');
INSERT 0 1
test1=# SELECT * FROM pg_create_logical_replication_slot('regression_slot',
'test_decoding');
slot_name | xlog_position
-----------------+---------------
regression_slot | 0/70BBAB0
(1 row)
cucm=# SELECT * FROM pg_logical_slot_get_changes('regression_slot', NULL,
NULL);
location | xid | data
----------+-----+------
(0 rows)
test1=# update test set t='world';
ERROR: Cannot run UPDATE or DELETE on table test because it does not have
a PRIMARY KEY.
HINT: Add a PRIMARY KEY to the table
FYI, the exact same command works just fine on stock PG9.4.5
And here is the postgresql bdr package that i used
[root(at)bdr301 /]# rpm -qa |grep post
postgresql-bdr94-2ndquadrant-redhat-1.0-3.noarch
postgresql-bdr94-libs-9.4.15_bdr1-1.el6.x86_64
postgresql-bdr94-contrib-9.4.15_bdr1-1.el6.x86_64
postgresql-bdr94-bdr-1.0.3-3.el6.x86_64
postgresql-bdr94-9.4.15_bdr1-1.el6.x86_64
postgresql-bdr94-server-9.4.15_bdr1-1.el6.x86_64
Thanks!
Ning
From | Date | Subject | |
---|---|---|---|
Next Message | Marco Nenciarini | 2018-01-05 15:46:09 | Re: [PATCH] Logical decoding of TRUNCATE |
Previous Message | Michael Paquier | 2018-01-04 23:04:42 | Re: Replication questions - read-only and temporary read/write slaves |