From: | Ken Tozier <kentozier(at)comcast(dot)net> |
---|---|
To: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Superuser log-in through a web interface? |
Date: | 2004-10-31 19:52:49 |
Message-ID: | 717C1447-2B76-11D9-93C1-003065F300E2@comcast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | mallah | 2004-10-31 20:26:14 | Re: procedural languages in 7.4.6 |
Previous Message | Tom Lane | 2004-10-31 19:44:51 | Re: Daylight Savings Time handling on persistent connections |