Обсуждение: Password and Installation

Hi,

I recently uninstalled PostgreSQL, and now am attempting to reinstall it on a Windows Vista OS. However, I don't remember the password that was used to install PostgreSQL before, and am prompted with "The password specified was incorrect. Please enter the correct password for the postgres windows user account."

I'm guessing that PostgreSQL wasn't fully uninstalled previously, and there are still some registry files or data files somewhere? Can my old password somehow be retrieved?

Thanks,

- Andrew

---

Visit messengerbuddies.ca to find out how you could win. Enter today.

On Fri, Nov 21, 2008 at 10:30 PM, Andrew Maeng <amaeng87@hotmail.com> wrote:
> Hi,
>
> I recently uninstalled PostgreSQL, and now am attempting to reinstall it on
> a Windows Vista OS. However, I don't remember the password that was used to
> install PostgreSQL before, and am prompted with "The password specified was
> incorrect. Please enter the correct password for the postgres windows user
> account."
>
> I'm guessing that PostgreSQL wasn't fully uninstalled previously, and there
> are still some registry files or data files somewhere? Can my old password
> somehow be retrieved?

No - it's a Windows user account, so the password cannot be retrieved
any more than your Administrator password can.

I don't know what the equivalent on Vista is, but on XP, open the
Computer Management tool under Administrative Tools, and you can reset
the password under the users section.

--
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com

Hi Andrew,

On Mon, Nov 24, 2008 at 12:10 AM, Andrew Maeng <amaeng87@hotmail.com> wrote:
> Thanks Dave. I can't seem to find the SQL user in the user accounts though.
> All i can see is the asp.net machine account.

Look for a user called 'postgres', not SQL.

> I'm guessing that this means that PostgreSQL is uninstalled, but I'm still
> unable to install PostgreSQL because I'm putting in the "wrong password".

The uninstaller doesn't remove the postgres user account because it
doesn't have any way of knowing if you're using it for other tools or
different versions of PostgreSQL. If the installer is reporting that
the password is incorrect, that's because there's an existing account
and Windows is telling us the password is wrong. If you can't find the
account for whatever reason, another way of removing it is to use the
command line tools. From a command prompt with administrator
privileges, try:

net user postgres /delete

It *should* be shown in the computer management applet though - but
the user accounts tool in Control Panel will hide service accounts (I
assume that applies to Vista as well as XP).

Regards, Dave.


--
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com