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/

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 2 | next ›
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedJan 22, '02 at 11:45a
activeJan 22, '02 at 12:11p
posts2
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Raphael Bauduin: 1 post Lukas Ertl: 1 post

People

Translate

site design / logo © 2022 Grokbase