Postgres Pro
Downloads
Home   >   mailing lists

psql -U postgres does not require a password - Mailing list pgsql-admin

From Silvan Calarco
Subject psql -U postgres does not require a password
Date
Msg-id 00110612055303.01091@coltrane.local.it
Whole thread Raw
Responses Re: psql -U postgres does not require a password  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: "Chris Fossenier"
Date:
Subject: Re: Problems allocating more memory
Next
From: "Dr. Hans-Christian Waldmann"
Date:
Subject: Re: psql -U postgres does not require a password