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 1fw1he-0000x2-Vr for pgsql-admin@arkaria.postgresql.org; Sat, 01 Sep 2018 08:56:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fw1hb-0003W6-Fy for pgsql-admin@arkaria.postgresql.org; Sat, 01 Sep 2018 08:56:19 +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 1fw1ha-0003Vy-Su for pgsql-admin@lists.postgresql.org; Sat, 01 Sep 2018 08:56:19 +0000 Received: from n3.nabble.com ([162.255.23.22]) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fw1hT-0002qu-SC for pgsql-admin@postgresql.org; Sat, 01 Sep 2018 08:56:17 +0000 Received: from n3.nabble.com (localhost [127.0.0.1]) by n3.nabble.com (Postfix) with ESMTP id 98D49EDAF259 for ; Sat, 1 Sep 2018 01:56:10 -0700 (MST) Date: Sat, 1 Sep 2018 01:56:10 -0700 (MST) From: pavan95 To: pgsql-admin@postgresql.org Message-ID: <1535792170623-0.post@n3.nabble.com> Subject: Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi Team, We have successfully configured and tested Logical Replication between Publisher and Subscriber. But on the Subscriber side we are getting generated a number of error log files(around 20-30 GB). The most common log messages found in the log(/var/log/postgresql/abc.log) are: 2018-08-26 06:32:09.659 IST [9385] ERROR: duplicate key value violates unique constraint "table_pkey" 2018-08-26 06:32:09.637 IST [13919] LOG: worker process: logical replication worker for subscription 4858103 sync 189974 (PID 9384) exited with exit code 1 2018-08-26 06:32:09.638 IST [13919] LOG: worker process: logical replication worker for subscription 4858103 sync 188985 (PID 9383) exited with exit code 1 Some 72 lakh times the above errors are occurring. How to prevent this behaviour? Kindly assist me!! Thanks in Advance. Regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html