Re: Problème password

On 2009-04-28, Bertrand Yohan Breyton Sanial <bbys43@hotmail.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