Re: How to automate password requests?

the name of env var is
PGPASSWORD
http://www.network-theory.co.uk/docs/postgresql/vol2/EnvironmentVariables1.h
tml

Viel Gluck
Martin-
----- Original Message -----
From: "Marten Lehmann" <lehmann(at)cnm(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, January 10, 2008 6:48 PM
Subject: Re: [GENERAL] How to automate password requests?

> Hello,
>
> >> TIP 5: don't forget to increase your free space map settings
> > Read about something called the .pgpass file. There's a way to set a
> > file that contains the password (pgAdmin will create one autmoatically)
> > that pgsql will look for before it asks for your password. It's stored
> > in ~/
> >
> > The solution I use is a bat file that redefines an environment variable
> > (PGPASSFILE) that points to the file, then runs pg_dumpall.
>
> is there no way to specify the password directly? I don't like to create
> a separate file because all config is done in a shell script. I could
> set a certain environment variable with the password, but does pgadmin
> read a password from such a variable? If yes, what is its name?
>
> Regards
> Marten
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>