/pgfreeze-qemu

Shell script to freeze postgres in kvm environment. This script allows to get consistent database point-in-time backup using VM snapshot.

Primary LanguageShellGNU General Public License v3.0GPL-3.0

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

  1. 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/
  1. Copy config file to /etc/default/
$ cp pgfreeze-qemu.example /etc/default/pgfreeze-qemu
  1. Enable fsfreeze-hook. Qemu guest agent should be running with option "-F".