Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4

From: soumitra bhandary <soumitra(dot)bhandary(at)hotmail(dot)com>
To: pavan95 <pavan(dot)postgresdba(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4
Date: 2018-09-03 05:58:47
Message-ID: MA1PR0101MB1687E0C4823BB4A9C430C7FCE00C0@MA1PR0101MB1687.INDPRD01.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Pavan ,

From Log it is evident that data integrity is failing both at Publisher and subscriber end .

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(dot)postgresdba(at)gmail(dot)com>
Sent: Monday, September 3, 2018 10:58 AM
To: pgsql-admin(at)postgresql(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message pavan95 2018-09-03 06:03:18 Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4
Previous Message pavan95 2018-09-03 05:28:37 Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4