Re: Heavy Logging in Subscriber side when configured LogicalReplication in 10.4

Поиск
Список
Период
Сортировка
От pavan95
Тема Re: Heavy Logging in Subscriber side when configured LogicalReplication in 10.4
Дата
Msg-id 1535961028810-0.post@n3.nabble.com
обсуждение исходный текст
Ответ на Re: Heavy Logging in Subscriber side when configured LogicalReplication in 10.4  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Ответы Re: Heavy Logging in Subscriber side when configured LogicalReplication in 10.4
Список pgsql-admin
Hi Achilleas,

But the logical Replication is working fine. I mean to say that the data is
replicating between Publisher and Subscriber. I have problem only with my
logs. Most common errors found on my Subscriber are:

1. duplicate key value violates unique constraint
2. worker process: logical replication worker for subscription 6992680 sync
694478 (PID 13459) exited with exit code 1
3. logical replication table synchronization worker for subscription
""subscription_name"", table ""tbl_A"" has started

>>Either you created the subscription while the subscriber already had
existing data in the tables, or you are inserting/updating dataI or Ds/keys
on the subscriber that cause the problem . 

Even if I did that it will face this error the very first time it is trying
to establish sync between publisher and subscriber but not every
time(correct me if I am wrong)

The 2'nd &  3'rd are not actually ERRORS. They are LOG messages. Please
suggest me if I went wrong somewhere. 



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html


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

Предыдущее
От: Achilleas Mantzios
Дата:
Сообщение: Re: Heavy Logging in Subscriber side when configured LogicalReplication in 10.4
Следующее
От: Achilleas Mantzios
Дата:
Сообщение: Re: Heavy Logging in Subscriber side when configured LogicalReplication in 10.4