Re: How to automate password requests? - Mailing list pgsql-general

From Marten Lehmann
Subject Re: How to automate password requests?
Date
Msg-id 4786AEBB.2060106@cnm.de
Whole thread Raw
In response to Re: How to automate password requests?  (Tom Hart <tomhart@coopfed.org>)
Responses Re: How to automate password requests?  ("Andrej Ricnik-Bay" <andrej.groups@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Jan Ischebeck
Date:
Subject: Pl/Java broken since Postgresql 8.3-rc1
Next
From: Tom Lane
Date:
Subject: Re: 8.2.4 serious slowdown