Re: I lost my password
От | |
---|---|
Тема | Re: I lost my password |
Дата | |
Msg-id | 7466E2130E7D4403834ACBEB3977EF2C@ArbolOnePC обсуждение исходный текст |
Ответ на | Re: I lost my password (Adrian Klaver <adrian.klaver@aklaver.com>) |
Ответы |
Re: I lost my password
Re: I lost my password |
Список | pgsql-general |
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@arbolone.ca ; PostGreSQL MailingList Subject: Re: [GENERAL] I lost my password On 07/26/2015 08:05 PM, papa@arbolone.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@arbolone.ca ; PostGreSQL MailingList > Subject: Re: [GENERAL] I lost my password > > 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления: