Backups with filesystem snapshots - Mailing list pgsql-general

From Nick Cleaton
Subject Backups with filesystem snapshots
Date
Msg-id CAFgz3ksJNVprBWLX4x=MdfJrG+uZSgUHTYGF35T=dJryJjz8zw@mail.gmail.com
Whole thread Raw
Responses Re: Backups with filesystem snapshots
Re: Backups with filesystem snapshots
List 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.



pgsql-general by date:

Previous
From: Charles Qi
Date:
Subject: Re: When UPDATE a row in a table with BEFORE ROW UPDATE trigger, the XMAX of new tuple is set to current XID
Next
From: Ron Johnson
Date:
Subject: Re: Backups with filesystem snapshots