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.
thanks
-----Original Message-----
From: Adrian Klaver
Sent: Sunday, July 26, 2015 11:09 PM
To: papa@xxxxxxxxxxx ; PostGreSQL MailingList
Subject: Re: I lost my password
On 07/26/2015 08:05 PM, papa@xxxxxxxxxxx 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@xxxxxxxxxxx ; PostGreSQL MailingList
Subject: Re: I lost my password
On 07/26/2015 07:51 PM, papa@xxxxxxxxxxx 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@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
