News for hackers. Stuff that matters.
Re:Postgres Incremental Backup by zilti on Friday January 12, 2024 @04:38AM (#38966005)
We simply take incremental ZFS snapshots
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?
Re:Postgres Incremental Backup by kevincox on Friday January 12, 2024 @06:54AM (#38967050)
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.

Re:Postgres Incremental Backup by sgarland on Friday January 12, 2024 @08:01AM (#38967450)
Nope, CoW is wonderful. Postgres will start up in crash recovery mode if you recover from a snapshot, but as long as you don’t have an insane amount of WAL to chew through, it’s fine.