From: | "Dr(dot) Hans-Christian Waldmann" <waldmann(at)samson(dot)fire(dot)uni-bremen(dot)de> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org, silvan(at)goemon(dot)polito(dot)it |
Subject: | Re: psql -U postgres does not require a password |
Date: | 2000-11-06 11:37:59 |
Message-ID: | 200011061137.eA6Bbxr27432@samson.fire.uni-bremen.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Mon, 6 Nov 2000 12:11:20 +0100, SILVAN wrote:
>
> I've just upgraded Redhat RPMs from Postgres 6.5.3 to 7.0.2 on two servers
> and run into the same problem on both. When I call the client psql:
>
> psql database_name -U postgres
>
> I'm not asked for a password and every user can access the database with
> postgres privileges.
> The password for postgres user is set (if I do a "select * from pg_shadow" I
> can see it). In addition this happens with every user, not just with postgres.
>
> What am I doing wrong ?
> Thanks.
>
> Silvan
>
I'm not really a postgres admin professional so accept my execuses in case
this hint is to dumb. Your password setting might have been kept in your
pg_shadow table while upgrading. It's just a table internal to the database,
after all. As far as I know, _Access_ is controlled by a file "pg_hba.conf"
which is _external_ to the database. I could imagine that your migration
install has simply overwritten the external file while preserving internal
tables. A default pg_hba.conf leads to the behavior described: anyone can
access any database with just a username. So please chekc this file.
HTH
Hans
---------------------------------------------------------------------
Dr. Hans C Waldmann
Methodology & Applied Statistics in Psychology & the Health Sciences
ZFRF / University of Bremen / Grazer Str 6 / 28359 Bremen / Germany
waldmann(at)samson(dot)fire(dot)uni-bremen(dot)de / http://samson.fire.uni-bremen.de
friend of: AIX PERL ADABAS SAS TEX
---------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2000-11-06 16:02:41 | Re: psql -U postgres does not require a password |
Previous Message | Silvan Calarco | 2000-11-06 11:11:20 | psql -U postgres does not require a password |