Re: Password entry in pgadmin3; pg_hba.conf vs .pgpass. Permissioning issue?

So I thought.... but all 3 lines seem to be required.

Actually that should have been a 4th question. Why do I need all those
3 lines in .pgpass? And why does an asterix for hostname achieve
nothing?

I tried the below but it doesn't work (at least with the md5
pg_hba.conf settings)

*:5432:*:postgres:Password
*:5432:*:django_dev:Password

Cheers,

Andy





On Tue, Dec 4, 2012 at 5:01 PM, Raymond O'Donnell <rod@iol.ie> wrote:
> On 04/12/2012 16:56, Andrew Taylor wrote:
>> Hi Guys,
>>
>> Thanks for your help. I have this working but don't completely
>> understand what I did.
>>
>> 1. Here is how the .pgpass file was originally written by pgadmin:
>>
>> 127.0.0.1:5432:*:postgres:Password
>> :5432:*:django_dev:Password
>>
>> 2. This is the amended version which allows pgadmin to automatically
>> connect to the server. All I have done is add line 3. All 3 lines seem
>> to be required to log on to the server.
>>
>> 127.0.0.1:5432:*:postgres:Password
>> :5432:*:django_dev:Password
>> localhost:5432:*:django_dev:Password
>
> Is that second line faulty? Shouldn't the first field contain either a
> hostname, an IP address or "*", but not simply nothing?
>
> Ray.
>
>
> --
> Raymond O'Donnell :: Galway :: Ireland
> rod@iol.ie