password help

Lists: pgsql-general
From: Guillermo Echevarria Quintana-Gurt <guieche(at)hotmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: password help
Date: 2012-07-29 18:30:23
Message-ID: SNT131-W382FC34445370E42F396E8BFC70@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

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(at)hotmail(dot)com
> From: webmaster(at)postgresql(dot)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.


From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: Guillermo Echevarria Quintana-Gurt <guieche(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: password help
Date: 2012-07-30 04:59:18
Message-ID: 501614A6.4040303@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

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