Hi,

While testing 'logical replication' against v10 , i encountered one issue where data stop migrating after ALTER PUBLICATION.


X Server
\\ Make sure wal_level is set to logical in postgresql.conf file
\\create table/Insert 1 row -> create table test(n int); insert into t values (1);
\\create publication for all -> create publication pub for ALL TABLES ;


Y server

\\ Make sure wal_level is set to logical in postgresql.conf file
\\create table -> create table test(n int);

\\create Subscription

CREATE SUBSCRIPTION sub CONNECTION 'host=localhost dbname=postgres port=5432 ' PUBLICATION pub;

postgres=# select * from test;
 n
---
 1
(1 row)

\\Alter subscription
postgres=# alter subscription sub connection 'host=localhost dbname=postgres PUBLICATION pub';
ALTER SUBSCRIPTION

X server
postgres=# insert into test values (1);
INSERT 0 1
postgres=# select * from test;
 n
---
 1
 1
(2 rows)

Y server
postgres=# select * from test;
 n
---
 1
(1 row)

I think probably syntax of alter subscription is not correct but surprisingly it is not throwing an error.

--
regards,tushar
EnterpriseDB  https://www.enterprisedb.com/
The Enterprise PostgreSQL Company



--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to