From: | Bjørn T Johansen <btj(at)havleik(dot)no> |
---|---|
To: | Gavin Love <gavin(at)aardvarkmedia(dot)co(dot)uk> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Changing password for the postgres user? |
Date: | 2005-06-23 13:47:24 |
Message-ID: | 42BABD6C.1020708@havleik.no |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Aaahh, of course.... I forgot about the trust settings I have there...
BTJ
Gavin Love wrote:
>
> Bjørn T Johansen wrote:
>
>> I am trying to change the password for the postgres user but it
>> doesn't work... I
>> have tried changing it from pgAdmin, EMS PostgreSQL Manager, etc but
>> whatever
>> password I set, I still can log in without using password.... (And it
>> seems that no
>> sql code is run on the server)
>>
>> What am i missing?
>
>
> Have you checked your pg_hba.conf ?
>
> It will be set to trust most likely which means the user doesn't need a
> password change it to crypt or password or md5 depending on your needs.
>
> http://www.postgresql.org/docs/8.0/interactive/client-authentication.html#EXAMPLE-PG-HBA.CONF
>
>
> Gavin
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2005-06-23 13:53:20 | Re: Performance counters? |
Previous Message | Cestmir Hybl | 2005-06-23 13:24:55 | Performance counters? |