From: | <papa(at)arbolone(dot)ca> |
---|---|
To: | "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com>, "PostGreSQL MailingList" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: I lost my password |
Date: | 2015-07-27 03:05:32 |
Message-ID: | 15D7C240F4EF40218E06FB51E2E470EC@ArbolOnePC |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?
-----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
--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2015-07-27 03:06:34 | Re: how to compile postgresql with other version of openssl? |
Previous Message | John McKown | 2015-07-27 03:02:36 | Re: I lost my password |