Re: Problème password

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Problème password
Date: 2009-04-29 12:42:53
Message-ID: gt9i0d$ud3$2@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 2009-04-28, Bertrand Yohan Breyton Sanial <bbys43(at)hotmail(dot)fr> wrote:
> --_81b99346-804a-46a1-86b8-0b19e1d6c356_
> Content-Type: text/plain; charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
>
> Bonjour=2C lorsque je souhaite lancer le logiciel poker tracker une fen=EAt=
> re s'affiche et me demande un "password" chose que je n'ai pas..
>
>=20
>
> Pouvez vous m'aider s'il vous plait?
>
>=20
>
> Serveur : localhost
>
> Port : 5432
>
> Database User : postgres
>
> Password : ????

password could be anything, it was chosen at install time (or caould
have been changed later).

in the file pg_hba.conf change the word "md5" or "password" to "trust"
and then you won't need a password.

you can now reset the password

ALTER USER postgres WITH PASSWORD 'new_password_goes_here';

or instead you could create a new superuser account... etc...

then turn the security back on by undoing then chages to pg_hba.conf

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message sam rab 2009-04-29 14:13:30 Help me to solve this problem!
Previous Message CK Leung 2009-04-29 11:15:44 sorting problem