Re: Can't connect to Windows port + other

Great, I found the part of the docs referring to this (ch 27.11) however, it
refers to creating this file in the user's home directory. It seems this
part of the documentation is assuming I'm using *nix. In Windows, where
should this file be located? Also, .pgpass is an invalid file name in Win.

Thanks!

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: September 1, 2004 5:19 PM
To: Anony Mous
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Can't connect to Windows port + other

"Anony Mous" <A(dot)Mous(at)shaw(dot)ca> writes:
> If so, why not set the listen_addresses to '*' right away?

Security. It was difficult enough to get people to accept the current
liberalized default --- I don't think they'll go for defaulting to -i,
which is essentially what you're asking for. It's seen as a good thing
that there are two, not one, levels of protection between you and having
a database server that's wide open to the entire internet.

> but it always fails because I don't know how to add the password for the
> super user into the command line, and of course the super user will always
> have a password. Is there a way to do this?

Create a .pgpass file maybe?

regards, tom lane