Postgres Pro
Downloads
Home   >   mailing lists

Publication/Subscription Questions - Mailing list pgsql-general

From xOChilpili
Subject Publication/Subscription Questions
Date
Msg-id CAM7=w_uk+BVB5A208x9COx5gCeg-qvoifHE3hAD9krBuV0k+dg@mail.gmail.com
Whole thread Raw
Responses Re: Publication/Subscription Questions
Re: Publication/Subscription Questions
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: logical replication snapshots
Next
From: Brahmam Eswar
Date:
Subject: Return Multiple Rows from Store Function