Re: pg_hba.conf / password, crypt,md5

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marc Ende <me(at)marc-ende(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_hba.conf / password, crypt,md5
Date: 2002-09-03 00:39:09
Message-ID: 28920.1031013549@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Marc Ende <me(at)marc-ende(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Nick Fankhauser 2002-09-03 00:56:55 Re: pg_hba.conf / password, crypt,md5
Previous Message Marc Ende 2002-09-03 00:01:27 pg_hba.conf / password, crypt,md5