4 ms·

We simply take incremental ZFS snapshots

• WolfOliver 3y ago
  do you need to stop the db for the backup in order to ensure consistency of the snapshot?
  • kevincox 3y ago
    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.
  • sgarland 3y ago
    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.