Re: Running rsync backups in pg15

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Murthy Nunna <mnunna(at)fnal(dot)gov>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Running rsync backups in pg15
Date: 2024-11-10 05:34:01
Message-ID: 6c1b0bc55c9420d84823dd6feda7620f69efac5e.camel@cybertec.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Murthy Nunna 2024-11-10 15:05:21 RE: Running rsync backups in pg15
Previous Message Laurenz Albe 2024-11-10 05:29:44 Re: How to check if session is a hung thread/session