Re: Changing password for the postgres user?

From: Gavin Love <gavin(at)aardvarkmedia(dot)co(dot)uk>
To: Bjørn T Johansen <btj(at)havleik(dot)no>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Changing password for the postgres user?
Date: 2005-06-23 11:52:11
Message-ID: 42BAA26B.8040307@aardvarkmedia.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Douglas McNaught 2005-06-23 12:12:04 Re: Changing password for the postgres user?
Previous Message Bjørn T Johansen 2005-06-23 11:34:28 Changing password for the postgres user?