Skip site navigation (1) Skip section navigation (2)

Re: Superuser log-in through a web interface?

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 (view raw or flat)
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


In response to

pgsql-general by date

Next:From: mallahDate: 2004-10-31 20:26:14
Subject: Re: procedural languages in 7.4.6
Previous:From: Tom LaneDate: 2004-10-31 19:44:51
Subject: Re: Daylight Savings Time handling on persistent connections

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group