Thread: postgres user work with any password!

postgres user work with any password!

From
Leandro Repolho
Date:
Hello guys, i installed my postgresql 8.0.2 successfuly and its
working fine, but my postgres user works with any password, how can i
solve ?
I already tryed to change the password trough the pgAdmin3 but didn´t worked!

Re: postgres user work with any password!

From
Bruno Wolff III
Date:
On Fri, Apr 22, 2005 at 11:14:35 -0300,
  Leandro Repolho <leandrorepolho@gmail.com> wrote:
> Hello guys, i installed my postgresql 8.0.2 successfuly and its
> working fine, but my postgres user works with any password, how can i
> solve ?
> I already tryed to change the password trough the pgAdmin3 but didn´t worked!

It sounds like you are using the "trust" authentication mechanism. What does
pg_hba.conf say?