Message-ID: <6c1b0bc55c9420d84823dd6feda7620f69efac5e.camel@cybertec.at>
Subject: Re: Running rsync backups in pg15
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Murthy Nunna <mnunna@fnal.gov>, Pgsql-admin
	 <pgsql-admin@lists.postgresql.org>
Date: Sun, 10 Nov 2024 06:34:01 +0100
In-Reply-To: 
 <DM8PR09MB667799AD3A5C891C2264A3AFB85E2@DM8PR09MB6677.namprd09.prod.outlook.com>
References: 
	<CANzqJaCr-id_4YotukPeH=rHCELS58Z63FoEbkNFBSqzjGMueQ@mail.gmail.com>
	 <01000193082d1077-34d9461d-49e4-44ef-b83a-0201df4fc0ba-000000@email.amazonses.com>
	 <DM8PR09MB6677705AE81436745B4487F6B85C2@DM8PR09MB6677.namprd09.prod.outlook.com>
	 <CANzqJaA02zeZTUB=uFPfxgJ+=NUUy1cQP3E0=3u0ssHdL6qkMA@mail.gmail.com>
	 <DM8PR09MB6677F19E2DDD6E18A4FDE2D6B85D2@DM8PR09MB6677.namprd09.prod.outlook.com>
	 <CANzqJaBZ+j2o8jQ8Hs63AQbAZfiFcyApa5d212A1LNkagqyrGQ@mail.gmail.com>
	 <DM8PR09MB66779BE5DA062DFB7257BE96B85D2@DM8PR09MB6677.namprd09.prod.outlook.com>
	 <bf3a4125-378c-4085-af26-e211c758e8ed@oss.nttdata.com>
	 <DM8PR09MB667799AD3A5C891C2264A3AFB85E2@DM8PR09MB6677.namprd09.prod.outlook.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.52.4 (3.52.4-2.fc40) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/6c1b0bc55c9420d84823dd6feda7620f69efac5e.camel%40cybertec.at>
Precedence: bulk

On Sat, 2024-11-09 at 17:24 +0000, Murthy Nunna wrote:
> I ran the test you outlined. Killed postmaster. Start failed. But simply =
removing the backup_label
> file made the server to restart successfully.
> There is no data corruption. Is there a scenario where data can be corrup=
ted because of exclusive backup?

You would normally end up with data corruption or an error if you removed "=
backup_label"
from a properly taken backup.  Manually removing "backup_label" is dangerou=
s.  It is safe
to do if the server crashed while in exclusive backup mode, but it is detri=
mental anywhere
else.

Yours,
Laurenz Albe