Postgres consistent point-in-time snapshot for KVM
Package description
This script allows to get consistent database point-in-time backup using Qemu/KVM snapshot.
Requirements
pgfreeze-qemu requires:
- qemu-guest-agent in VM with Postgres RDBMS
Compatibility
Tested with:
- Postgres 14, 15
- Proxmox 6, 7 (KVM)
- VM with Debian 9, 10, 11
How to install
- Copy script pgfreeze-qemu.sh to qemu guest agent fsfreeze-hook directory. By default, it should be /etc/qemu/fsfreeze-hook.d/. See 'man qemu-ga'
$ cp pgfreeze-qemu.sh /etc/qemu/fsfreeze-hook.d/
- Copy config file to /etc/default/
$ cp pgfreeze-qemu.example /etc/default/pgfreeze-qemu
- Enable fsfreeze-hook. Qemu guest agent should be running with option "-F".