Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fwizG-0006Dw-UD for pgsql-admin@arkaria.postgresql.org; Mon, 03 Sep 2018 07:09:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fwizE-0007A9-VK for pgsql-admin@arkaria.postgresql.org; Mon, 03 Sep 2018 07:09:24 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fwizE-00079t-Jr for pgsql-admin@lists.postgresql.org; Mon, 03 Sep 2018 07:09:24 +0000 Received: from hermes.gatewaynet.com ([193.92.121.98]) by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fwizA-0005hP-1N for pgsql-admin@lists.postgresql.org; Mon, 03 Sep 2018 07:09:23 +0000 Received: from smadev.internal.net (pc131.internal.net [10.9.200.131]) by hermes.gatewaynet.com (8.14.3/8.14.3/Debian-9.4) with ESMTP id w83799DP003205 for ; Mon, 3 Sep 2018 10:09:14 +0300 Received: from smadev.internal.net (smadev [10.9.200.131]) by smadev.internal.net (8.15.2/8.15.2) with ESMTP id w83798Ns063554 for ; Mon, 3 Sep 2018 10:09:09 +0300 (EEST) (envelope-from achill@matrix.gatewaynet.com) Subject: Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4 To: pgsql-admin@lists.postgresql.org References: <1535792170623-0.post@n3.nabble.com> <1535952517864-0.post@n3.nabble.com> From: Achilleas Mantzios Message-ID: <5714bce7-ea22-95a7-6a3a-1a220e906cb9@matrix.gatewaynet.com> Date: Mon, 3 Sep 2018 10:09:08 +0300 User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:52.0) Gecko/20100101 Thunderbird/52.6.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------6D67FC12302623D38E03F67A" Content-Language: en-US X-Virus-Scanned: clamav-milter 0.98.7 at hermes X-Virus-Status: Clean X-Spam-Status: No, score=-36.9 required=5.0 tests=ALL_TRUSTED,DYN_HAM_COORD, DYN_HAM_IT,DYN_HAM_IT_PARTNERS,DYN_HAM_NAUTICAL,DYN_SPAM_MED6,HTML_MESSAGE, TW_PG autolearn=unavailable version=3.3.1 X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on hermes.gatewaynet.com List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------6D67FC12302623D38E03F67A Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit 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 > *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 --------------6D67FC12302623D38E03F67A Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit
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
--------------6D67FC12302623D38E03F67A--