Hi!

I have Amanda server running on a Linux box. In another machine, I have Solaris 9 running Amanda client and PostgreSQL. I would like to know if someone has experience backupping PostgreSQL with Amanda.

I have thought the following solutions:

1. Making a file system level backup. The problem is that I'll have to stop the PostgreSQL engine first, so the DB will be unoperative for a while.

2. To use pg_dump to get a hot snapshot of the desired DB, put it on some directory and then backup that directory with amanda.

I saw somewhere a kind of script that interacts between Oracle and Amanda, and it is possible to backup the desired DB without stopping the engine. Is there something like that for postgreSQL??

Any idea??

Bests Regards

Germán C. Basisty
EIP Sistemas
Consultor - Tecnología informática
Paso 158 (Q8340FTG)
Zapala, Pcia. de Neuquén
Argentina
tel. +54 (02942) 422 336
fax +54 (02942) 422 336
german.basisty AT eipsistemas.ath DOT cx
HYPERLINK "http://www.eipsistemas.ath.cx"http://www.eipsistemas.ath.cx

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.6.10 - Release Date: 10/01/2005