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: (view raw, whole thread or download thread mbox)
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          trust
> and change 'trust' to your preferred auth method (password, md5, etc.)
> Check out the docs for authentication methods at
> authentication.html

Thanks Vinko that did the trick.


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-2017 The PostgreSQL Global Development Group