Re: Postgresql backup via LVM snapshot?

2019-06-03 Thread Fabio Ugo Venchiarutti
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

Re: Postgresql backup via LVM snapshot?

2019-06-03 Thread Bruno Lavoie
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

Postgresql backup via LVM snapshot?

2019-05-30 Thread Lu, Dan
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