On Fri, Feb 07, 2003 at 12:07:23 +0530,
Shridhar Daithankar <shridhar_daithankar@persistent.co.in> wrote:
> On Thursday 06 February 2003 09:34 pm, you wrote:
> > The goal is to have cron run some backup scripts (to dump the databases
> > daily) without having to enter a password for the dumps.
>
> Run psql script. You can use PGPASSWORD environment variable. Search
> archives. It has the references..
This isn't a good idea. If you are worried enough about local users
to use password authentication, you don't want to put passwords into
environment variables as on most unix systems they are visible to other
users.
Using ident authentication is a much better way to do this.
