Обсуждение: password help
Hi, I just uninstalled version 8.4 and tried installing version 9.1 in my computer (my system is Windows 7). The issue Im facing was that when I clicked run to install the new version one of the steps was requiring me the following:
"please provide a password for the database superuser (postgres) and service account (postgress). If the service account already exists in windows, you must enter the current password for the account. If the account doesnt exist, it will be created when you click "next""
I typed many possible passwords I could have but all of them tell me its incorrect. So I would like to know if there is a password I had related to my account or computer with the previous version I had? Dont even think i had an account in the past because i tried creating one now with this email that is my primary and was able to create a new account.I also read this blogpost http://pgsnake.blogspot.com/2010/07/postgresql-passwords-and-installers.html but still havent been able to figure out how to solve that password issue. I would really appreciate if you could help me out with this issue. Thanks a lot for your time.
Guillermo
> Date: Sat, 28 Jul 2012 18:04:50 +0000
> Subject: Your new postgresql.org community account
> To: guieche@hotmail.com
> From: webmaster@postgresql.org
>
> You are receiving this e-mail because you requested a new
> PostgreSQL community account.
>
> Please go to the following page and choose a new password:
>
> https://www.postgresql.org/account/reset/24q-39e-6458006552e65a88da70/
>
> Your username, in case you've forgotten, is guieche.
> Subject: Your new postgresql.org community account
> To: guieche@hotmail.com
> From: webmaster@postgresql.org
>
> You are receiving this e-mail because you requested a new
> PostgreSQL community account.
>
> Please go to the following page and choose a new password:
>
> https://www.postgresql.org/account/reset/24q-39e-6458006552e65a88da70/
>
> Your username, in case you've forgotten, is guieche.
On 07/30/2012 02:30 AM, Guillermo Echevarria Quintana-Gurt wrote:
Hi, I just uninstalled version 8.4 and tried installing version 9.1 in my computer (my system is Windows 7). The issue Im facing was that when I clicked run to install the new version one of the steps was requiring me the following:
"please provide a password for the database superuser (postgres) and service account (postgress). If the service account already exists in windows, you must enter the current password for the account. If the account doesnt exist, it will be created when you click "next""
As per the blog you linked to, open an administrator command prompt by right-clicking on the command prompt entry it in the start menu and choosing "Run as administrator", then in the command prompt run:
net user postgres *
and enter a new password when prompted.
If you can't find the command prompt in the start menu, just type "command" into the Start menu search box and it will appear in the list.
Alternately, try completely uninstalling all PostgreSQL versions, then using the system management console to delete the "postgres" user. You cannot do this via the "users" control panel, it must be done via the usermgmt mmc snapin, which you can find called User Management within Administrative Tools in the control panel.
It seems the 9.2 installers will use a different setup that won't require a service password anymore. (Thanks Dave!).
--
Craig Ringer
Please don't reply directly to me, reply via the mailing list (use "Reply all"). On 07/30/2012 01:35 PM, Guillermo Echevarria Quintana-Gurt wrote: > Hi Craig, I really appreciate your answer. My situation is the one I described you in the first email. I guess i should'veadd that i really have no clue about how to use/run or do anything related with postgresql, i downloaded it becausei was told I had to have it in order for a software i was going to use to work (holdem manager). I installed it andthings worked fine, dont remember anytime doing anything with or to postgres. My problem comes now that I upgraded toholdem manager 2 and cant get to open it, i was told that it COULD be related to something to postgres and i could tryuninstalling and reinstalling it again to see if things worked then. I tried that but as told encountered the passwordproblem. This is a Holdem Manager issue. They've done a silent installation of PostgreSQL, and their upgrade tool clearly doesn't do its job right. Please contact their technical support for assistance. -- Craig Ringer
On 07/30/2012 02:00 PM, Guillermo Echevarria Quintana-Gurt wrote:
A google search for "windows 7 administrator command prompt" reveals:Im contacting them tomorrow for sure. My issue is that I uninstalled the postgresql system from my computer and now I cant get it installed again because of the password issue. Thats all im trying to solve, getting the postgresql installed again in my laptop and like said because of being really really clulesss im having issues with that and im really sorry for taking your time on helping me.
http://technet.microsoft.com/en-us/library/cc947813(v=ws.10).aspx
and
http://www.howtogeek.com/howto/windows-vista/run-a-command-as-administrator-from-the-windows-vista-run-box/
both of which explain in detail how to open a command prompt as administrator. It's similarly easy to find instructions on how to get to the administrative tools in the control panel.
The best way to be less "clueless" - as you call yourself - about computers is to actively learn by trying to research things when you run into problems. These days Google will often find the answer if you try a few different ways to ask the question.
Try re-reading Dave's blog post slowly. When you encounter something you don't understand, look it up. It will take longer that way, but you will learn more and most importantly you will be more able to solve your own problems in future.
--
Craig Ringer
Im contacting them tomorrow for sure. My issue is that I uninstalled the postgresql system from my computer and now I cant get it installed again because of the password issue. Thats all im trying to solve, getting the postgresql installed again in my laptop and like said because of being really really clulesss im having issues with that and im really sorry for taking your time on helping me.
> Date: Mon, 30 Jul 2012 13:49:03 +0800
> From: ringerc@ringerc.id.au
> To: guieche@hotmail.com; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] password help
>
> Please don't reply directly to me, reply via the mailing list (use
> "Reply all").
>
> On 07/30/2012 01:35 PM, Guillermo Echevarria Quintana-Gurt wrote:
> > Hi Craig, I really appreciate your answer. My situation is the one I described you in the first email. I guess i should've add that i really have no clue about how to use/run or do anything related with postgresql, i downloaded it because i was told I had to have it in order for a software i was going to use to work (holdem manager). I installed it and things worked fine, dont remember anytime doing anything with or to postgres. My problem comes now that I upgraded to holdem manager 2 and cant get to open it, i was told that it COULD be related to something to postgres and i could try uninstalling and reinstalling it again to see if things worked then. I tried that but as told encountered the password problem.
> This is a Holdem Manager issue. They've done a silent installation of
> PostgreSQL, and their upgrade tool clearly doesn't do its job right.
>
> Please contact their technical support for assistance.
>
> --
> Craig Ringer
> From: ringerc@ringerc.id.au
> To: guieche@hotmail.com; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] password help
>
> Please don't reply directly to me, reply via the mailing list (use
> "Reply all").
>
> On 07/30/2012 01:35 PM, Guillermo Echevarria Quintana-Gurt wrote:
> > Hi Craig, I really appreciate your answer. My situation is the one I described you in the first email. I guess i should've add that i really have no clue about how to use/run or do anything related with postgresql, i downloaded it because i was told I had to have it in order for a software i was going to use to work (holdem manager). I installed it and things worked fine, dont remember anytime doing anything with or to postgres. My problem comes now that I upgraded to holdem manager 2 and cant get to open it, i was told that it COULD be related to something to postgres and i could try uninstalling and reinstalling it again to see if things worked then. I tried that but as told encountered the password problem.
> This is a Holdem Manager issue. They've done a silent installation of
> PostgreSQL, and their upgrade tool clearly doesn't do its job right.
>
> Please contact their technical support for assistance.
>
> --
> Craig Ringer