Re: backing up postgres / informix ?

[Galen Johnson]

John P. Looney wrote:

Hi, I was wondering if anyone had solutions for backing up live
databases.

I've some (smallish) databases - around 2GB maybe, that I'd like to
backup. I was wondering how amanda could be configured to do this.

Is it possible to do something like getting the amanda user to run a
script shutting down the database, while it runs tar/dump on the database
filesystems ? (or, as in the case of informix, the raw partitions) ?

This is on the amanda todo list

Or, am I better off having a huge disk on the database boxes, and doing a
dump of the databases as SQL to disk every night, before the backup is run ?

Prety sure this is your best option. Just dump the DB and have amanda back that up. Of course, if you use tar I believe some folks have written wrapper scripts for databade backups.
=G=