Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: pg_hba.conf / password, crypt,md5
Date
Msg-id 28920.1031013549@sss.pgh.pa.us
Whole thread Raw
In response to pg_hba.conf / password, crypt,md5  (Marc Ende <me@marc-ende.de>)
List pgsql-admin
Tree view 
Marc Ende <me@marc-ende.de> writes:
> 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

That should still work ...

> 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.

Did you SIGHUP the postmaster after editing the pg_hba.conf file?
Are you sure you are editing the same file the postmaster is looking at?

            regards, tom lane

pgsql-admin by date:

Previous
From: Marc Ende
Date:
Subject: pg_hba.conf / password, crypt,md5
Next
From: "Nick Fankhauser"
Date:
Subject: Re: pg_hba.conf / password, crypt,md5