2ndQuadrant / pglogical

Logical Replication extension for PostgreSQL 17, 16, 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades.
http://2ndquadrant.com/en/resources/pglogical/
Other
1.01k stars 153 forks source link

create_subscription() with synchorize_structure := true creates objects not in the replication set #14

Closed mw2q closed 8 years ago

mw2q commented 8 years ago
provider (pg1) subscriber (pg2)
create database 94to94p; create database 94to94s
\c 94to94p \c 94to94s
create table a (z integer primary key);
create schema s1;
create table s1.a (z integer primary key);
create schema s2;
create table s2.a (z integer primary key);
select * from pglogical.create_replication_set(set_name := 's1');
SELECT pglogical.create_subscription(subscription_name := 'subscription1', replication_sets := ARRAY['s1'], provider_dsn := 'host=pg1 dbname=94to94p');

Schema s1 and s2, and tables public.a, s1.a and s2.a are created on the subscriber.

PJMODOS commented 8 years ago

That's known limitation, there isn't plan to change this in near future.