Re: How to automate password requests?

From: Marten Lehmann <lehmann(at)cnm(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to automate password requests?
Date: 2008-01-10 23:48:11
Message-ID: 4786AEBB.2060106@cnm.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message marcelo Cortez 2008-01-10 23:50:42 Re: [GENERAL] 8.3beta bug or feature?
Previous Message Jan Ischebeck 2008-01-10 23:21:03 Pl/Java broken since Postgresql 8.3-rc1