On Oct 31, 2004, at 12:40 PM, Vinko Vrsalovic wrote:
<snip>
This is probably because pg_hba.conf settings. By default, it trusts
connections from localhost, which means that any connection being made
from localhost (which is the case when the web server and database are
running in the same machine) will be accepted regardless of user and password.
You should change these lines in pg_hba.conf
local all all trust # IPv4-style local connections: host all all 127.0.0.1/32 trust
and change 'trust' to your preferred auth method (password, md5, etc.)
Check out the docs for authentication methods at
http://www.postgresql.org/docs/7.4/interactive/client- authentication.html
Thanks Vinko that did the trick.
Ken
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
