Re:Postgres Incremental Backup
by WolfOliver on Friday January 12, 2024 @06:38AM
(#38966913)
do you need to stop the db for the backup in order to ensure consistency of the snapshot?
[ Parent
| on HN ]
You shouldn't because a filesystem snapshot should be equivalent to hard powering off the system. So any crash-safe program should be able to be backed up with just filesystem snapshots.
There will likely be some recovery process after restoring / rollback as it is effectively an unclean shutdown but this is unlikely to be much slower than regular backup restoration.