Обсуждение: automated pg_dump

Hi,

is there a way to make an automated dump with pg_dump when the database
access is password protected?
I'd like to run it from a cron. However, I haven't found a way to
mention the password on the command line (Which is
not the most secure solution, but needed to run it non interactively
from a script).

Thanks for your help!

Raph

On Tue, 22 Jan 2002, Raphael Bauduin wrote:

> is there a way to make an automated dump with pg_dump when the database
> access is password protected?
> I'd like to run it from a cron. However, I haven't found a way to

I do a daily backup with a shell script like this:

---8<---
#!/bin/sh

export PGUSER=<username>
export PGPASSWORD=<password>

/usr/local/bin/pg_dumpall > dump.sql
---8<---

This should be definitely more documented, as it took me also quite long
to find out :-)

regards,
le

--
Lukas Ertl                             eMail: l.ertl@univie.ac.at
UNIX-Systemadministrator               Tel.:  (+43 1) 4277-14073
Zentraler Informatikdienst (ZID)       Fax.:  (+43 1) 4277-9140
der Universität Wien                   http://mailbox.univie.ac.at/~le/