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

On 03/09/2018 08:58, soumitra bhandary wrote:
> 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(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
>

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