Backups with filesystem snapshots

From: Nick Cleaton <nick(at)cleaton(dot)net>
To: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Backups with filesystem snapshots
Date: 2025-08-11 13:01:15
Message-ID: CAFgz3ksJNVprBWLX4x=MdfJrG+uZSgUHTYGF35T=dJryJjz8zw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

If I take an instantaneous filesystem-level snapshot of the postgres
data directory underneath a running postgres server, is that a safe
backup without doing any pg_start_backup/pg_stop_backup ?

It seems like it should be, so long as I get an atomic snapshot that
includes both data and wal, because starting up from that snapshot
should look the same as recovering from an unclean postgres shutdown
due to a kernel panic.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2025-08-11 13:13:38 Re: Backups with filesystem snapshots
Previous Message Charles Qi 2025-08-11 03:34:08 Re: When UPDATE a row in a table with BEFORE ROW UPDATE trigger, the XMAX of new tuple is set to current XID