On 13 Jun 2002, 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.
Checkout pg_dump(1). Setup a cron job which runs pg_dump to a logrotate
style directory of database dumps which are picked up by amanda in its
nightly run.
--
Brandon D. Valentine <[EMAIL PROTECTED]>
Computer Geek, Center for Structural Biology
"This isn't rocket science -- but it _is_ computer science."
- Terry Lambert on [EMAIL PROTECTED]
