Re: Superuser log-in through a web interface? - Mailing list pgsql-general

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