On Thu, Jun 13, 2002 at 02:13:39PM -0500, Kirk Strauser wrote: > I just finished reading `Unix Backup and Recovery' and realized that there > are quite a few holes in my disaster recovery plan. In particular, I'm > looking for a way to backup PostgreSQL without taking the database offline. > I'm assuming that whatever method I use will involve writing a wrapper > script to prepare the backup, launch Amanda, then clean up afterward, but > that's about as much as I've guessed right now.
Alternatively to the pg_dump approach others have suggested you can snapshot your filesystem and then use regular backup. The easiest way to snapshot the filesystem is to use a logical volume manager (LVM or EVMS on linux) and then do: 1. take database offline 2. take snapshot 3. take database online 4. backup from snapshot 5. remove snapshot -- Ragnar Kjørstad Big Storage
