Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1jr1gU-0007PM-8O
	for pgsql-admin@arkaria.postgresql.org; Thu, 02 Jul 2020 16:03:34 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1jr1gT-0001aT-7S
	for pgsql-admin@arkaria.postgresql.org; Thu, 02 Jul 2020 16:03:33 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <sfrost@tamriel.snowman.net>)
	id 1jr1gS-0001aM-VQ
	for pgsql-admin@lists.postgresql.org; Thu, 02 Jul 2020 16:03:32 +0000
Received: from tamriel.snowman.net ([2001:470:e38f::11])
	by makus.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <sfrost@tamriel.snowman.net>)
	id 1jr1gQ-0008F5-QQ
	for pgsql-admin@postgresql.org; Thu, 02 Jul 2020 16:03:31 +0000
Received: by tamriel.snowman.net (Postfix, from userid 1000)
	id 60E7E5F79F; Thu,  2 Jul 2020 12:03:30 -0400 (EDT)
Date: Thu, 2 Jul 2020 12:03:30 -0400
From: Stephen Frost <sfrost@snowman.net>
To: Praveen Kumar K S <praveenssit@gmail.com>
Cc: Jeff Janes <jeff.janes@gmail.com>,
	pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: [HELP] Issue with standby server using WAL archive
Message-ID: <20200702160330.GV3125@tamriel.snowman.net>
References: 
 <CANSiNp6iAACN_4HjHUqFEmTOd_0QvdBiE5W1XXjwFniNwUWAYQ@mail.gmail.com>
 <20200702141444.GJ3125@tamriel.snowman.net>
 <CANSiNp6y1tm08Z=mDj6RL33iUjM1ozw6DtKY7Dz6FofxLvFNqA@mail.gmail.com>
 <20200702152608.GQ3125@tamriel.snowman.net>
 <CANSiNp4MiEBrOgK3s-Ljw7poNFeb8_oL9HuTt-hZfhqYiendFQ@mail.gmail.com>
 <CAMkU=1yrnu7OoCshf2oA+vi2UK_iJ0zX_aUYSOZgTAso_po77Q@mail.gmail.com>
 <CANSiNp5qBbY+gn2xqsZJ6aTeNqeMRgpLxf63N5G3CZUecTFcbA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="+ri2T0IZgb46yOXM"
Content-Disposition: inline
In-Reply-To: 
 <CANSiNp5qBbY+gn2xqsZJ6aTeNqeMRgpLxf63N5G3CZUecTFcbA@mail.gmail.com>
User-Agent: Mutt/1.5.24 (2015-08-30)
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk


--+ri2T0IZgb46yOXM
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

Greetings,

* Praveen Kumar K S (praveenssit@gmail.com) wrote:
> But if you look at the output below, 00000001000000000000000D is already
> 16MB and new WAL are created. As per my understanding,
> 00000001000000000000000D should have been archived. Am I wrong here ?

Yes, you're wrong- WAL files are re-used and will always be 16MB even if
they aren't yet completed.

Thanks,

Stephen

--+ri2T0IZgb46yOXM
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQIcBAEBCgAGBQJe/gVSAAoJEO1sijiDR2RVFSgP/RpqF4i0eKWd2RJb0SOw1Il1
UQgHfxCGS2TLV2Woy2+ExiWgd/ZPfiTBIJdrUkBu+vjRZ7miqXtExRUfvEDJlqCf
QDnF86aEatoPPWZ9ouoWAcuv63HFwr92evs2RBd7vFxxt2uyi6Ov/in+W/xd39Oc
Vjk44PKuUcr0H9uh5CuxOe+5bhVTz4kdFDUJhTrktiy3ogaD2AubISrmj1t0HZx6
cMkL9isDpTxI2T0Urlw8S1bVqYUIQg42gzZenAyGO8/fYllLu5StWbikshzbxJi/
LWjcYr5lAYn8ITOsLKgpLv1CBQWfQ/jXEVbkCKPFXyrkXde1LbliSaxImstBmjtN
02HIBQmDBLwVaigHflrUqR3XKLisbTmhKbhR7ATwv2NIVv52OclhURV5/27mtGAq
UXpJgnTRaB+Tzd+LeryEnRLu59lKkQiuPUdWRD6Uf1yEu1twIiiEcigFsCNyO/SM
QIYrBJFCVkMwtQ8oUHtN8aTBrwUOLMAlqPjnKRw32Fbth0QjRPCFRaTTD90y5JId
cs5KrHBM2fG6+d39MnpWDn97XGe8Phg/hCcO4OKvn3GMZKVCqCKRbqd3zmdodAiK
E7PVHelsrN52GPtXadqYIDkNJNFKUwkLlZYD9Q6+9dQPCyIFVywmNBfUOMCeZACQ
9I9lqnCqUGgold9PQi09
=dpNp
-----END PGP SIGNATURE-----

--+ri2T0IZgb46yOXM--