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 1freEm-0002uF-3J for pgsql-admin@arkaria.postgresql.org; Mon, 20 Aug 2018 07:04:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1freEk-00079g-G3 for pgsql-admin@arkaria.postgresql.org; Mon, 20 Aug 2018 07:04:26 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1freEk-00079Z-91 for pgsql-admin@lists.postgresql.org; Mon, 20 Aug 2018 07:04:26 +0000 Received: from n3.nabble.com ([162.255.23.22]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1freEh-0002uu-Jw for pgsql-admin@postgresql.org; Mon, 20 Aug 2018 07:04:25 +0000 Received: from n3.nabble.com (localhost [127.0.0.1]) by n3.nabble.com (Postfix) with ESMTP id 98F9EEA6A5AB for ; Mon, 20 Aug 2018 00:04:21 -0700 (MST) Date: Mon, 20 Aug 2018 00:04:21 -0700 (MST) From: pavan95 To: pgsql-admin@postgresql.org Message-ID: <1534748661624-0.post@n3.nabble.com> In-Reply-To: References: <1534224580242-0.post@n3.nabble.com> <1534746282900-0.post@n3.nabble.com> <1534747341264-0.post@n3.nabble.com> Subject: Re: logical Replication 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 >> But When I insert data in the publisher, And perform a check on the >> subscriber, it is not getting replicated(most of the times) until I drop >> and >> recreate my SUBSCRIPTION. >OS? (Linux, BSD, etc) *Ubuntu 16.04.5 LTS* >PostgreSQL Version? *PostgreSQL 10.4 (Ubuntu 10.4-2.pgdg16.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.9) 5.4.0 20160609, 64-bit* >Also give the current settings of wal_receiver_timeout , wal_sender_timeout , increasing those to '5 min' solved my issues. *1) wal_receiver_timeout: 1min 2) wal_sender_timeout: 1min* How increasing above params related to the replication lag? Looking forward hearing from you!!! Regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html