I am currently using
the pg_hotbackup Perl script to backup my production PostgreSQL database.
However, the next production database is going to be close to a terrabyte in
size. We feel that a tar cvzf command is not the correct OS backup
solution to use. Instead we would like to use lvmsnapshot. Is anyone
using the pg_hotbackup script but instead of the tar cvzf OS command are
they using lvmsnapshot?
Or, is anyone using
lvmsnapshot and doing point-in-time recoveries?
Thanks,
Sandra Arnold
Sr. Database
Administrator
DOE/OSTI
Oak Ridge,
TN