Hi everyone, Im just testing/learning how subscriptions and publications work, then this is what i have done until now:
Server A : create database test_pubsubs; create table foo( id_foo serial not null primary key, foo varchar(20) not null ); insert into foo values(1,'foo'); insert into foo values(2,'foobar'); create table foobar( id_foobar serial not null primary key, foobar varchar(20) not null ); insert into foobar values(1,'foobaz'); insert into foobar values(2,'foobax'); create publication my_publication for table foo; Server B : create database test_pubsubs; create table foo( id_foo serial not null primary key, foo varchar(20) not null ); create table foobar( id_foobar serial not null primary key, foobar varchar(20) not null ); create subscription my_subscription connection 'host=server_a dbname=test_pubsubs user=my_user password=my_password port=5432' publication my_publication; select * from foo; id_foo | foo 1 | foo 2 | foobar select * from foobar; 0 Rows Server A: alter publication my_publication add table foobar; Server B: alter subscription my_subscription refresh publication; select * from foobar; id_foobar | foobar 1 | foobaz 2 | foobax Then, here's my question : Still on Server B: delete from foo; delete from foobar; select * from foo; 0 Rows select * from foobar; 0 Rows alter subscription my_subscription refresh publication; select * from foo; 0 Rows select * from foobar; 0 Rows Why ? If i remove rows, from Server B and refresh publication, why data is not re-sync ? But if i : drop subscription my_subscription; and create it again, then i have all data back... Thanks a lot! -- xOCh -- PAranoids Group 218
