On Fri, Sep 16, 2005 at 11:13:31AM -0500, J French wrote: > We are setting up Debian Linux on a new server for a PostGreSQL database. In > the past, on FreeBSD, I used the dump utility with the live filesystem > (snapshot) switch to backup the running database. Does dump on linux support > live filesystem backups as well? How are most people backing up to tape with > Debian (or linux in general)? I need a robust backup because this will be a > production server. Advice is appreciated.
First, migrate your partitions to LVM. Then use snapshot to take a snapshot of the postgres partition, then use the backup tool of your choice to backup the snapshot to tape. I use bacula for that because it lets you do backup schedules and it can call scripts before and after to create/delete the snapshot. This solution will give you the smallest downtime for your postgres database, without worrying about data integrity issues. -- Dave Carrigan Seattle, WA, USA [EMAIL PROTECTED] | http://www.rudedog.org/ UNIX-Apache-Perl-Linux-Firewalls-LDAP-C-C++-DNS-PalmOS-PostgreSQL-MySQL-Postfix
signature.asc
Description: Digital signature
