[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: Tape Backup advice needed - dump, tar etc.

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
dave@rudedog.org | http://www.rudedog.org/

Attachment: signature.asc
Description: Digital signature

Reply to: