Re: Changing password for the postgres user? - Mailing list pgsql-general

From Gavin Love
Subject Re: Changing password for the postgres user?
Date
Msg-id 42BAA26B.8040307@aardvarkmedia.co.uk
Whole thread Raw
In response to Changing password for the postgres user?  (Bjørn T Johansen <btj@havleik.no>)
Responses Re: Changing password for the postgres user?
List pgsql-general
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

pgsql-general by date:

Previous
From: Bjørn T Johansen
Date:
Subject: Changing password for the postgres user?
Next
From: Douglas McNaught
Date:
Subject: Re: Changing password for the postgres user?