Re: I lost my password

On 07/26/2015 08:05 PM, papa(at)arbolone(dot)ca wrote:
> I am using windows 8.1 and what I believe to be the latest version of
> posgresql from postgresql.org.
> Would it be better to reinstall postgresql?

So what password are you talking about?

I doubt this requires reinstalling.
>
> -----Original Message----- From: Adrian Klaver
> Sent: Sunday, July 26, 2015 11:01 PM
> To: papa(at)arbolone(dot)ca ; PostGreSQL MailingList
> Subject: Re: [GENERAL] I lost my password
>
> On 07/26/2015 07:51 PM, papa(at)arbolone(dot)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(dot)klaver(at)aklaver(dot)com