Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gUCmC-0003zC-B5 for pgsql-admin@arkaria.postgresql.org; Tue, 04 Dec 2018 15:38:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gUCmA-0008Gm-Vk for pgsql-admin@arkaria.postgresql.org; Tue, 04 Dec 2018 15:38:18 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1gUCmA-0008Gf-Nr for pgsql-admin@lists.postgresql.org; Tue, 04 Dec 2018 15:38:18 +0000 Received: from tamriel.snowman.net ([2001:470:e38f::11]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gUCm7-0004Ze-CB for pgsql-admin@postgresql.org; Tue, 04 Dec 2018 15:38:17 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 2EB7C5F7A6; Tue, 4 Dec 2018 10:38:14 -0500 (EST) Date: Tue, 4 Dec 2018 10:38:14 -0500 From: Stephen Frost To: AYahorau@ibagroup.eu Cc: MikalaiKeida@ibagroup.eu, pgsql-admin , Shreeyansh Dba Subject: Re: pg_basebackup fails: could not receive data from WAL stream: server closed the connection unexpectedly Message-ID: <20181204153814.GP3415@tamriel.snowman.net> References: <20181204140512.GO3415@tamriel.snowman.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="8IXbTAy87sU8bUFQ" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --8IXbTAy87sU8bUFQ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, * AYahorau@ibagroup.eu (AYahorau@ibagroup.eu) wrote: > Is there any relation/dependency between status-interval and=20 > wal_sender_timeot.? Yes, if pg_basebackup doesn't ping the server with a status interval within wal_sender_timeout amount of time then the server is going to think it's disappeared. > I am asking this because even if I set status-interval for pg_basebacku= p=20 > to 1 second( the most frequent feedback) I get the same error: Sure- if they're both set to 1s, you're likely to still see the issue. Networks take time and systems can end up being busy, so having such a very tight timeout is, frankly, unlikely to work out all that well for you regardless. You could try setting wal_sender_timeout to 2s or maybe 5s and see if that works better. Thanks! Stephen --8IXbTAy87sU8bUFQ Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJcBp9lAAoJEO1sijiDR2RVfJwP/iWcIFbTxyF6JfBS+4hGGgJk HVCS/MbY7Ar75MwYvHqYSL76R8K0Ja0c0KcUG7uAAH7WYgWuUgvrV54yHsPJCxOw 6VuYxm66Ri1km3hL54sWN4BBWaceQz4M3J4d0wAiE9XYeg3Onemf4+eZYVCiuYcw Hi2lKqsmvXjO02i1/5khHNYhOOiTJ/9oGl3YD/C1Gc4Lu3aU4h9ts7WUY2SeW37p Wja421q6re6obpxIJ3EW+BN00AhS7X0fgcWsA+/E9jrUbf2SfmA9NNh0yMBLGE5G EBhfrUvtYtaG3TjLytA3gH3UwIF7NgYhtSjhDa3/SK4SOwB8ZKt3UdTFBJZBu9ql /BDCaFvde/uZsYxpV2MiFZyX9CZO/MfGMMysI8wiiiqKJVSqXlFc09HNtymYluOF PoZoc3iGJFBQBKPZI225oj5wBqILzDy6VOSBeOfKYG/Po2U2lFY06mqUVk/mF+Wk 1hLVIx6jtFJp4+rdffGA7LXbDpPm7uixabVYAbZ4YkTNESFezbvEFAeMJG3vq8Dl Y0pSyl6r/xpu7tlIG9nAf7FPiPC+seuzi4HqTlZU8n+s6EuhZd/YgCm9mlhDxDgF a/uGaOUHGjhQcT53ljMncqvYcu+OXOXX3Fv0PTeGj1/u0UyMyUQ0YUHTnfkG8ZkU eb5uug/5lYmRfrYqGQ3b =xEnZ -----END PGP SIGNATURE----- --8IXbTAy87sU8bUFQ--