Backup passwd protected DB

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-admin by date

  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]