Slide 49
Slide 49 text
Backup a database
# lvcreate -L1G -s -n pg-tmp \
/dev/vg01/postgres;
# mount --type xfs \
-o'ro,norecovery,nouuid' /dev/vg01/pg-tmp
/mnt/backup;
# find /mnt/backup -xdev …
/mnt/backup is stable for duration of backup.
/var/postgres keeps writing.