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
Дата
Msg-id 5714bce7-ea22-95a7-6a3a-1a220e906cb9@matrix.gatewaynet.com
обсуждение исходный текст
Ответ на Re: Heavy Logging in Subscriber side when configured LogicalReplication in 10.4  (soumitra bhandary <soumitra.bhandary@hotmail.com>)
Список pgsql-admin
On 03/09/2018 08:58, soumitra bhandary wrote:
P {margin-top:0;margin-bottom:0;}
Hi Pavan , 


From Log it is evident that data integrity is failing both at Publisher and subscriber end .
At Publisher? how? He does not suggest anything like this. If the failure was on the publisher side, you wouldn't even notice this on the subscriber side.

This may be due to several reason , so you have to remove that conflict first . 

2018-08-26 06:32:09.659 IST [9385] ERROR:  duplicate key value violates 
unique constraint "table_pkey" 


Thanks ,
Soumitra 


From: pavan95 <pavan.postgresdba@gmail.com>
Sent: Monday, September 3, 2018 10:58 AM
To: pgsql-admin@postgresql.org
Subject: Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4
 
Community,

Looking forward to hear your advices.




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


-- 
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt

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

Предыдущее
От: pavan95
Дата:
Сообщение: 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