On Tue, 17 Jun 2003, scott.marlowe wrote:
> On Tue, 17 Jun 2003, Mel Jamero wrote:
> > to get to the psql interface we execute:
> > psql dbname -U user
> > is it possible to disable the -U option such that a user cannot invoke the
> > privileges of a database superuser such as postgres?
> > tried looking up pg_hba.conf regarding 'password' authentication, the man
> > pages and the archives but didn't get too lucky.
> Did you stop / start postgresql after the changes? Make sure you don't
> have a line for "trust" 127.0.0.1 as well.
As a followup to that, look into ident method of authentication as well.
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2003-06-17 16:13:14|
|Subject: Re: Vacuum & Memory Exhausted error |
|Previous:||From: Greg Spiegelberg||Date: 2003-06-17 14:33:48|
|Subject: Vacuum & Memory Exhausted error|