Re: pg_hba.conf / password, crypt,md5

Marc-

Just a guess here, but perhaps your new install is looking for pg_hba in a
different place, so the old one isn't getting referenced. The behavior you
describe sounds a lot like a default pg_hba.

-Nick

--------------------------------------------------------------------------
Nick Fankhauser nickf(at)ontko(dot)com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/

> -----Original Message-----
> From: pgsql-admin-owner(at)postgresql(dot)org
> [mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of Marc Ende
> Sent: Monday, September 02, 2002 7:01 PM
> To: pgsql-admin(at)postgresql(dot)org
> Subject: [ADMIN] pg_hba.conf / password, crypt,md5
>
>
> 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(at)marc-ende(dot)de
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>