Re: I lost my password

On 07/26/2015 08:15 PM, papa(at)arbolone(dot)ca wrote:
> OK, I think I should tell you folks that I am a newbie. I am using
> postgresql to learn the SQL for the purpose of learning storing the data
> in my c++ application. I have near zero knowledge of SQL or PostgreSQL
> for that matter.
> When I type C:\pgsql, I am asked to entered a password, but I don't
> recall the any passwords I might've set up at installation time.

Well I do not use Windows much and not all for Postgres so I am at bit
of lose here. I did find this:

http://www.enterprisedb.com/docs/en/9.3/pginstguide/PostgreSQL_Installation_Guide-07.htm#P138_8268

which indicates a password is asked for in the install.

You have no recollection of that being asked or a clue as to what
password you may have used?

Since the password is used for both the database and the service account
and assuming you have not actually done anything with the database, I
take back my earlier comment about not reinstalling. It might be easier
to do that then going through all the steps necessary to reset in place,
given that you are just starting out.

>
> thanks
>
> -----Original Message----- From: Adrian Klaver
> Sent: Sunday, July 26, 2015 11:09 PM
> To: papa(at)arbolone(dot)ca ; PostGreSQL MailingList
> Subject: Re: [GENERAL] 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