Are you trying to fit the postgres backups in some overarching LVM-based
backup scheme you're already running or is this from scratch?
With the possible exception of rsync's deltas & hardlink trickeries
between full backups, I personally don't see a point in using a
block/file-level copy for
Hi,
I suggest you to take a serious look at ZFS: https://zfsonlinux.org/
With simply a few commands, mainly zpool and zfs, you can manage
everything in one stack:
* encryption: new in 0.8.0
* compression: with lz4, it's very lightweitgh with practically no
impact on cpu
* snapshots: it
Hello,
Would you be able to confirm for me that a host level LVM snapshot of the
PGDATA directory along with PG_WAL directly via LVM backup is supported way of
backup and restore?
I read about this here:
https://dba.stackexchange.com/questions/145361/backup-standby-database-using-lvm-snapshot