[HACKERS] 'nocopy data' option is set in SUBSCRIPTION but still data is gettingmigrated

Поиск
Список
Период
Сортировка
От tushar
Тема [HACKERS] 'nocopy data' option is set in SUBSCRIPTION but still data is gettingmigrated
Дата
Msg-id 75b35b5c-138d-ecb5-9786-eaa3e48ed92a@enterprisedb.com
обсуждение исходный текст
Ответы Re: [HACKERS] 'nocopy data' option is set in SUBSCRIPTION but stilldata is getting migrated  (Petr Jelinek <petr.jelinek@2ndquadrant.com>)
Список pgsql-hackers
Hi,

Please refer this scenario -where 'nocopy data' option is set in 
SUBSCRIPTION but still data is getting migrated

Publication - (X)
create table t(n int);
insert into t values (generate_series(1,99));
create publication pub for table  t;

Subscription (Y)
create table t(n int);
CREATE SUBSCRIPTION sub CONNECTION 'dbname=postgres host=localhost 
port=5000 user=centos password=a' PUBLICATION pub WITH (copy 
data,SYNCHRONOUS_COMMIT=on);
select count(*) from t;  ->showing 99 rows
alter subscription sub refresh publication with (nocopy data);
restart the server (Y)

X - insert more records into table 't'
Y - check the row count , rows have been migrated from X .

Is it the right behavior in this case where nocopy data option is set ?

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




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [HACKERS] Removal of plaintext password type references
Следующее
От: Petr Jelinek
Дата:
Сообщение: Re: [HACKERS] [BUGS] Concurrent ALTER SEQUENCE RESTART Regression