| From: | "Magnus Hagander" <mha(at)sollentuna(dot)net> |
|---|---|
| To: | <tope(dot)akinniyi(at)shepherdhill(dot)biz>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: ~/pgpass |
| Date: | 2005-08-16 09:10:57 |
| Message-ID: | 6BCB9D8A16AC4241919521715F4D8BCE6C78B3@algol.sollentuna.se |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mage | 2005-08-16 09:27:45 | Re: atomic function |
| Previous Message | Martijn van Oosterhout | 2005-08-16 09:07:28 | Re: 5 new entries for FAQ |