Date: Thu, 25 Nov 2021 07:45:46 +0900
From: Michael Paquier <michael@paquier.xyz>
To: SATYANARAYANA NARLAPURAM <satyanarlapuram@gmail.com>
Cc: Pg Hackers <pgsql-hackers@postgresql.org>
Subject: Re: Postgres restart in the middle of exclusive backup and the
 presence of backup_label file
Message-ID: <YZ7Amotspa4ve+91@paquier.xyz>
References: 
 <CAHg+QDfiM+WU61tF6=nPZocMZvHDzCK47Kneyb0ZRULYzV5sKQ@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="SqDznlTUUXc/HDVr"
Content-Disposition: inline
In-Reply-To: 
 <CAHg+QDfiM+WU61tF6=nPZocMZvHDzCK47Kneyb0ZRULYzV5sKQ@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/YZ7Amotspa4ve%2B91%40paquier.xyz>
Precedence: bulk


--SqDznlTUUXc/HDVr
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Wed, Nov 24, 2021 at 02:12:19PM -0800, SATYANARAYANA NARLAPURAM wrote:
> While an exclusive backup is in progress if Postgres restarts, postgres
> runs the recovery from the checkpoint identified by the label file instead
> of the control file. This can cause long recovery or even sometimes fail =
to
> recover as the WAL records corresponding to that checkpoint location are
> removed. I can write a layer in my control plane to remove the backup_lab=
el
> file when I know the server is not in restore from the base backup but I
> don't see a reason why everyone has to repeat this step. Am I missing
> something?

This is a known issue with exclusive backups, which is a reason why=20
non-exclusive backups have been implemented.  pg_basebackup does that,
and using "false" as the third argument of pg_start_backup() would
have the same effect.  So I would recommend to switch to that.
--
Michael

--SqDznlTUUXc/HDVr
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmGewJoACgkQnvQgOdby
QH2Hig/8Deq0UOsMxU07zn/8vptL8kxtVpMQRTZZC6cRULoTX3iyTjU5HV+rjzBi
Pam7YRjawVgEV1W8+glSwbWNlaZ1JLZGRXr6+MY+GAw7iFlTbXrqFA9z/iN27/AN
wn+oJFAHdIkrXODGLTSZgFIQ0dUBJb6RAFw8PeasMSFPIcaSfruu2kRYrJ/c+jf5
pYXtaWfNkx7YFHwZDY/WCIg2APxRPm62M75Y1tOHQbC330HA6JjLlRsLCHYuS2ml
r6zuCQOB8WwTImJoUmcsPSMtQeZ0kX7UrwPl0x22DGsK9HRKOYf0iatS1TjYhdue
FmdT0elGrF+HYRNMjkvVlRrA/16S9zfTJ3HPEWokBWL4VjImQxOGygMEpCjMnp6l
meFSLXZ8bOV8j1SnLX5V6VH9RXqFMUj/HJex1LlN0/U71hCj5F4E+AX8x+1cjiOa
asHflLz9pvfNaJBsG6tPIjP85E2E0GPQJzfeap92SqmP9aVrdKw/TkMJlDM1b1KB
M59kd/R/u0yP2rRGDUbtIdumcl7+Bp2sql+JHNvRMU4jRLAUiTG8lZXY49fVfRUP
0tJfKXDbCkBQD5CX26GYcdEsXFcdp1oyTCD3C00hR6+fEbe354vH5OOt1xeV2lvS
y4Kd6mt3oLnULzJYShUTovlfXkQ9g+GG4dwHsbvCIHpQx+ZfXL0=
=CSDH
-----END PGP SIGNATURE-----

--SqDznlTUUXc/HDVr--