Re: password help

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