Re: password help - Mailing list pgsql-general

From Craig Ringer
Subject Re: password help
Date
Msg-id 501614A6.4040303@ringerc.id.au
Whole thread Raw
In response to password help  (Guillermo Echevarria Quintana-Gurt <guieche@hotmail.com>)
List 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

pgsql-general by date:

Previous
From: Edson Richter
Date:
Subject: Enums documentation "glitch"
Next
From: Craig Ringer
Date:
Subject: Re: password help