| From: | Lukas Ertl <l(dot)ertl(at)univie(dot)ac(dot)at> |
|---|---|
| To: | Raphael Bauduin <raphael(at)be(dot)easynet(dot)net> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: automated pg_dump |
| Date: | 2002-01-22 12:11:20 |
| Message-ID: | 20020122130917.O32751-100000@pcle2.cc.univie.ac.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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(dot)ertl(at)univie(dot)ac(dot)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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Boyle (Roselink) | 2002-01-22 22:03:21 | Re: automatically updated an attribute with the current time |
| Previous Message | Raphael Bauduin | 2002-01-22 11:46:01 | automated pg_dump |