Re: Running rsync backups in pg15 - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: Running rsync backups in pg15
Date
Msg-id 6c1b0bc55c9420d84823dd6feda7620f69efac5e.camel@cybertec.at
Whole thread Raw
In response to RE: Running rsync backups in pg15  (Murthy Nunna <mnunna@fnal.gov>)
Responses RE: Running rsync backups in pg15
List pgsql-admin
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 corrupted 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 dangerous.  It is safe
to do if the server crashed while in exclusive backup mode, but it is detrimental anywhere
else.

Yours,
Laurenz Albe



pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: How to check if session is a hung thread/session
Next
From: Murthy Nunna
Date:
Subject: RE: Running rsync backups in pg15