From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4
Date: Mon, 3 Sep 2018 10:09:08 +0300
Message-ID: <5714bce7-ea22-95a7-6a3a-1a220e906cb9@matrix.gatewaynet.com> (raw)
In-Reply-To: <MA1PR0101MB1687E0C4823BB4A9C430C7FCE00C0@MA1PR0101MB1687.INDPRD01.PROD.OUTLOOK.COM>
References: <1535792170623-0.post@n3.nabble.com>
<1535952517864-0.post@n3.nabble.com>
<MA1PR0101MB1687E0C4823BB4A9C430C7FCE00C0@MA1PR0101MB1687.INDPRD01.PROD.OUTLOOK.COM>
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.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: achill@matrix.gatewaynet.com, pgsql-admin@lists.postgresql.org
Subject: Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4
In-Reply-To: <5714bce7-ea22-95a7-6a3a-1a220e906cb9@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox