Re: [GENERAL] Password and Installation

2008-11-24 Thread Dave Page
Hi Andrew,

On Mon, Nov 24, 2008 at 12:10 AM, Andrew Maeng [EMAIL PROTECTED] 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

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[GENERAL] Password and Installation

2008-11-21 Thread Andrew Maeng

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

_



Re: [GENERAL] Password and Installation

2008-11-21 Thread Dave Page
On Fri, Nov 21, 2008 at 10:30 PM, Andrew Maeng [EMAIL PROTECTED] 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

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general