pg_hba.conf / password, crypt,md5 - Mailing list pgsql-admin

From Marc Ende
Subject pg_hba.conf / password, crypt,md5
Date
Msg-id 17m12t-0Sp6qeC@fmrl01.sul.t-online.com
Whole thread Raw
Responses Re: pg_hba.conf / password, crypt,md5  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: pg_hba.conf / password, crypt,md5  ("Nick Fankhauser" <nickf@ontko.com>)
List pgsql-admin
Hi there,

I think it might be a well known problem, but I haven't found a solution.

I've used a postgres 7.0 before. Now I need to upgrade to an actual version (7.2.2).
In the "old" pg_hba.conf I had the both lines in the pg_hba.conf:
local    all                    password
host    all    127.0.0.1 255.255.255.255 password

now I've tried the same but now I can logon as a valid user with an invalid password.
Postgres now allows to login with any valid username without specifying a password.

After that I'm trying to use other authorization types but it didn't gave me the
security back :(

Thanks for any hint.

Yours sincerly

Marc Ende
--

Marc Ende
consulting and development
http://www.marc-ende.de/                    me@marc-ende.de

pgsql-admin by date:

Previous
From: Randall Perry
Date:
Subject: Re: pgsql 7.2.2: problem compiling on Sol 8
Next
From: Tom Lane
Date:
Subject: Re: pg_hba.conf / password, crypt,md5