Re: I lost my password - Mailing list pgsql-general

From Adrian Klaver
Subject Re: I lost my password
Date
Msg-id 55B59EEE.8010304@aklaver.com
Whole thread Raw
In response to I lost my password  (<papa@arbolone.ca>)
Responses Re: I lost my password  (<papa@arbolone.ca>)
List pgsql-general
On 07/26/2015 07:51 PM, papa@arbolone.ca wrote:
> After installing PostgreSQL I lost the password, how can I recover it?

What OS?

How did you install?

What password are you talking about?

Assuming you are talking about a Postgres password, take a look at:

http://www.postgresql.org/docs/9.4/interactive/auth-pg-hba-conf.html

 From there you can set the local connection to trust and then access
Postgres. From there you can reset the password using ALTER USER:

http://www.postgresql.org/docs/9.4/interactive/sql-alteruser.html


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Yves Dorfsman
Date:
Subject: Re: I lost my password
Next
From: John McKown
Date:
Subject: Re: I lost my password