When I use psql with -u option, psql prompts for the user and password
but any password lets me through although psql checks for the user.
What am I missing here?
On Oct 17, lec mentioned:
> When I use psql with -u option, psql prompts for the user and password
> but any password lets me through although psql checks for the user.
>
> What am I missing here?
Passwords only make sense if you actually use password authentication (see
pg_hba.conf(5)), otherw
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
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
"Dr. Hans-Christian Waldmann" wrote:
> 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