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/