| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Andreas Hierling <A(dot)Hierling(at)netcafe-konstanz(dot)de> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Set Passsword for existing User |
| Date: | 2002-02-21 22:59:24 |
| Message-ID: | 20020221145735.J23226-100000@megazone23.bigpanda.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Sun, 17 Feb 2002, Andreas Hierling wrote:
> I know, this should work with "ALTER USER...", But when I set the
> password this way, im still able to gain unrestricted access without a
> password. When setting a Password by creating the user, theres no such
> problem. Im working with PostgreSQL 7.1 on a SuSE 7.1 Linux. Hope
> anyone knows this Problem or is able to tell me what i have done wrong.
Are you sure that you've set up pg_hba.conf correctly? In most cases not
being prompted for a password is due to a trust entry there.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2002-02-21 23:01:52 | Re: Problem/Question |
| Previous Message | Bruce Momjian | 2002-02-21 21:52:37 | Re: FATAL 1: configuration file 'postgresql.conf' has wrong |