Re: ~/pgpass - Mailing list pgsql-general

From Magnus Hagander
Subject Re: ~/pgpass
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE6C78B3@algol.sollentuna.se
Whole thread Raw
In response to ~/pgpass  (Oluwatope Akinniyi <tope.akinniyi@shepherdhill.biz>)
List pgsql-general
> > On Fedora: wrong file permissions?
> > Btw.: ~/.pgpass is only supported in 7.3 and later.
>
> Thanks.
>
> The permission is 0600 on Fedora. But must the file
> (~/.pgpass) be owned by postgres? Also what could explain the
> reason why it is not working on Windows XP where permission
> is not checked!
>
> I am running version 8.0.3 that is shipped with Fedora Core 4.
>
> The content of both ~/.pgpass and pgpass.conf is:
>
> 192.168.0.253:5432:hms:xxxxxx

That's not the correct format. See
http://www.postgresql.org/docs/8.0/static/libpq-pgpass.html:

hostname:port:database:username:password

You are either missing database or userid, depending on what "hms" is.

//Magnus

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: 5 new entries for FAQ
Next
From: Mage
Date:
Subject: Re: atomic function