| From: | "Nathalie Boulos" <nathalieboulos(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Backup passwd protected DB |
| Date: | 2003-05-26 09:29:27 |
| Message-ID: | BAY8-F45J8VrRQvXlao00008054@hotmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hello,
I need to backup a postgresql-7.3.2 DB with a user having a password using
cron.
every time i call pg_dump I get prompted for a password. It's OK if i'm
running it from command line. But when i use cron, the backup couldn't be
executed because no password is given.
I don't want to put the password in clear text in any file for security
reasons, and i don't want to grant read access to a "backup" user with no
password.
is there any solution to dump that database?
Thanks for your help
Regards
Nathalie
_________________________________________________________________
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Victor Yegorov | 2003-05-26 09:59:03 | Re: Backup passwd protected DB |
| Previous Message | ewdani | 2003-05-26 08:31:25 | Inquiry From Form [pgsql] |