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 <r...@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 > r...@iol.ie -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
