The password specified was incorrect...

Hi,
New here and I got a small issue...

Downloaded postgresql-8.3.7-1-windows.exe file from EnterpriseDB as the "One Click Installer".
When the installer reaches the step for entering the password for database superuser and service account (postgres) after I have entered a password then the response is:

The password specified was incorrect. Please enter the correct password for the postgres windows user account.

Now, as I did not not created any user account I just entered a password of my own as the text says "If the account does not exist, it will be created when you click 'next'.
I then create a user account as ST7501PGSQL with a passowrd, tried a new installation, but got same result...

So what am I doing wrong?

The installer tries to create a service account 'postgres' ( which in turn is used as database superuser ) if the 'postgres' user account does not exist on your system. In this case, simple provide any password and a user 'postgres' with the supplied password gets created.

In case your system already has a 'postgres' user (may be from previous PostgreSQL installations) then provide the password for that user. If your password supplied doesn't match with the actual password of existing user 'postgres', then you will get an error message.

The password specified was incorrect. Please enter the correct password for the postgres windows user account.

In case, you dont remember the 'postgres' password, you can delete (if possible) that user and start the installation again.

--
Regards,
Sachin Srivastava
www.enterprisedb.com

Sachin,
Thanks for your reply...

I forgot to say in my first post, I never had PostgreSQL installations on the machine before.
This was my first time, as I needed to have PostgreSQL installed as an IP Camera Application requires PostgreSQL.

Between each attempt I clean the PC and I tried after having done roll back to a point in time before I tried the first installation.
The PC is pretty clean only Windows and OpenOffice installed, the IP Camera Application not yet installed as PostgreSQL is not up and running.

I will try again this time by creating a postgres user account first, to see if that changes anything.
BR// Steen

hi ,
i am new to postgres, and to this forum, but i am having the same problem, even my system does not have postgres installed on it, but everytime i try to install it it gives the same problem, also i checked the window users , no such user physically exists on the system, but still this problem is present

Hello,

You must be having a 'postgres' user account in your system as that is the only way you can get the error message you got.

Try this command,

After this run the installer again.

If that doesn't solve your problem, please post the content of installation log which can be found in your system's temp directory(%TEMP\install-postgresql.log or %TEMP\bitrock_installer.log).

If there are multiple bitrock_installer_XXXX.log files post the content of the most recent one.

GO to Control Panel=> Administrative Tools=> Computer Management=> Local User and Groups and delete the postgres user from there and try installation after wards. It would be a success.

thks Sumit it was a savior to delete postgres user using control panel.
I tried cmd line and it give me access denied for "net user postgres /delete". wooooh

I have to uninstall the entire PostgreSQL package becuz I forgot a freaking password that nobady said was important because I forgot it for the PostGIS installation? What a pain in the ___

How about including a "Change password" in the PG III admin GUI or a option in PostGIS installation "Use PostgreSQL password automatically" ?

thanks sumit was trying to install postgreSQL n i don't have much idea about it tried some other links none of them worked but ur method worked .
anyways i am new to postgreSQL so can u suggest me some forums or books or websites where i can get more information about it

Thank you very much Sumit

This message was edited 4 times. Last update was at 16 Apr 2011 08:31:10

I tried to install the oneclickinstaller postgresql-9.0.3-2-windows.exe (Installing postgresql on Debian / Ubuntu - postgresql works fine and perfect). Now I have to install it on a windows 7 32Bit system and iam desperated.
There was definitly no postgresql installation on this system!

I tried several workarrounds:
1. I deleted the user by net user postgres /delete and started the installer again - no effect
2. I deleted and created the user postgres, set an own password and started the installer again - no effect
3. I changed the password by net user postgres * and started the installer again - no effect

Always the same error message: The password specified was incorrect.

Has Anyone a great idea to solve this problem?

Something went wrong and i don`t know what it is.

My log:

Log started 04/16/11 at 13:42:57
Preferred installation mode : qt
Trying to init installer in mode qt
Mode qt successfully initialized
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.0 Data Directory. Setting variable iDataDirectory to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.0 Base Directory. Setting variable iBaseDirectory to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.0 Service ID. Setting variable iServiceName to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.0 Service Account. Setting variable iServiceAccount to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.0 Super User. Setting variable iSuperuser to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.0 Branding. Setting variable iBranding to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.0 Version. Setting variable brandingVer to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.0 Shortcuts. Setting variable iShortcut to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.0 DisableStackBuilder. Setting variable iDisableStackBuilder to empty value
[13:43:08] Existing base directory: 
[13:43:08] Existing data directory: 
[13:43:08] Using branding: PostgreSQL 9.0
[13:43:08] Using Super User: postgres and Service Account: postgres
[13:43:08] Using Service Name: postgresql-9.0
Executing cscript //NoLogo "C:\Users\XXXXXX\AppData\Local\Temp\prerun_checks.vbs"
Script exit code: 0

Script output:
 The scripting host appears to be functional.

Script stderr:

Executing cscript //NoLogo "C:\Users\XXXXXX\AppData\Local\Temp\postgresql_installer\installruntimes.vbs" "C:\Users\XXXXXX\AppData\Local\Temp\postgresql_installer\vcredist_x86.exe"
Script exit code: 0

Script output:
 Executing the runtime installer: C:\Users\XXXXXX\AppData\Local\Temp\postgresql_installer\vcredist_x86.exe
installruntimes.vbs ran to completion

Script stderr:

Executing C:\Users\XXXXXX\AppData\Local\Temp\postgresql_installer\getlocales.exe 
Script exit code: 0

Script output:
AfrikaansxxCOMMAxxxxSPxxSouthxxSPxxAfrica=Afrikaans, South Africa
AlbanianxxCOMMAxxxxSPxxAlbania=Albanian, Albania
AlsatianxxCOMMAxxxxSPxxFrance=Alsatian, France
AmharicxxCOMMAxxxxSPxxEthiopia=Amharic, Ethiopia
[...]

Script stderr:

Executing C:\Users\XXXXXX\AppData\Local\Temp\postgresql_installer\createuser.exe "." "postgres" "****"
Script exit code: 0

Script output:
 User account 'XXXXXX\postgres' already exists.
Granted the 'Log on as a service' right to 'XXXXXX\postgres'
C:\Users\XXXXXX\AppData\Local\Temp\POSTGR~1\CREATE~1.EXE ran to completion

Script stderr:

Executing C:\Users\XXXXXX\AppData\Local\Temp\postgresql_installer\validateuser.exe "." "postgres" "****"
Script exit code: 1

Script output:
 Incorrect password for user 'XXXXXX\postgres'.

Script stderr:
 Program ended with an error exit code

Error running C:\Users\XXXXXX\AppData\Local\Temp\postgresql_installer\validateuser.exe "." "postgres" "****" : Program ended with an error exit code
Executing C:\Users\XXXXXX\AppData\Local\Temp\postgresql_installer\createuser.exe "." "postgres" "****"
Script exit code: 0

Script output:
 User account 'XXXXXX\postgres' already exists.
C:\Users\XXXXXX\AppData\Local\Temp\POSTGR~1\CREATE~1.EXE ran to completion

Script stderr:

Executing C:\Users\XXXXXX\AppData\Local\Temp\postgresql_installer\validateuser.exe "." "postgres" "****"
Script exit code: 1

Script output:
 Incorrect password for user 'XXXXXX\postgres'.

Script stderr:
 Program ended with an error exit code

Error running C:\Users\XXXXXX\AppData\Local\Temp\postgresql_installer\validateuser.exe "." "postgres" "****" : Program ended with an error exit code
Executing C:\Users\XXXXXX\AppData\Local\Temp\postgresql_installer\createuser.exe "." "postgres" "****"
Script exit code: 0

Script output:
 User account 'XXXXXX\postgres' already exists.
C:\Users\XXXXXX\AppData\Local\Temp\POSTGR~1\CREATE~1.EXE ran to completion

Script stderr:

Executing C:\Users\XXXXXX\AppData\Local\Temp\postgresql_installer\validateuser.exe "." "postgres" "****"
Script exit code: 1

Script output:
 Incorrect password for user 'XXXXXX\postgres'.

Script stderr:
 Program ended with an error exit code

Error running C:\Users\XXXXXX\AppData\Local\Temp\postgresql_installer\validateuser.exe "." "postgres" "****" : Program ended with an error exit code
Deleting registry keys

I cant find the local User and Groups folder. I'm windows vista. Help?

GO to Control Panel=> Administrative Tools=> Computer Management=> Local User and Groups and delete the postgres user from there and try installation after wards. It would be a success.

angryjun wrote:I tried to install the oneclickinstaller postgresql-9.0.3-2-windows.exe (Installing postgresql on Debian / Ubuntu - postgresql works fine and perfect). Now I have to install it on a windows 7 32Bit system and iam desperated.
There was definitly no postgresql installation on this system!

I tried several workarrounds:
1. I deleted the user by net user postgres /delete and started the installer again - no effect
2. I deleted and created the user postgres, set an own password and started the installer again - no effect
3. I changed the password by net user postgres * and started the installer again - no effect

Always the same error message: The password specified was incorrect.

Has Anyone a great idea to solve this problem?

Something went wrong and i don`t know what it is.

I am having this problem as well and I have tried the same methods with no results. Please help, this is pretty frustrating.

HELLO PLEASE HELP ME! I CANT INSTALL.

Hello,

Did nothing from the above comments help you get around the problem? Have you tried giving a non-existent user and a password for it so that installer will create a new user for you.. Can you post the error part of the log?

Are you installing from a user which is an administrator or part of administrator group?

Anything in the windows event logs?

We happen to test the installers on a variety of Windows flavors as :WinXP (32 & 64), Vista (32 & 64), Windows Server 2003 & 2008 (32 & 64) and Windows 7 (32 & 64). All of them are clean machines..

This message was edited 2 times. Last update was at 25 Oct 2011 04:11:35

Hello

Have the sameproblem, as the topicstarter.

I installed one version of Postgresq, deleted it, and tryin to install another version. Same error message.

I have folder "postgre" in Users folder, but when im tryin to delete it through control panel, there s no this user in list of users. System Win7x64

Also i tried command u wrote (net user/delete), but it says i dont have enough rights.

Any ideas how to fix it?

P.s. I also dont have any log file in c:/temp directory..

I found a solution to the ''not enough rights'' message when entering the ''net user /delete'' command.

1) You need to go in:
Control Panel --) User Accounts and Family Safety ---) User Accounts ---) Change User Account Control settings

2) Then you have to set the notification level to ''Never notify'' which is the lowest.

3) Restart computer

4) Try the command ''net user /delete'' again.

This message was edited 2 times. Last update was at 13 Feb 2012 02:58:43

Hi Steen_H

I have the same problem, but find a solution that might this can help you out.

Might be you have previous installation of Postgres either installed by you or by any other application on your system. for retrieving passowrd for 'postgres' user (may be from previous PostgreSQL installations) one needs to look for file "pgpass.conf" on path "C:\Users\admin\AppData\Roaming\postgresql\pgpass.conf". and then use the password given in file.

For example: text in above file

<Server>:<Port>:*:<User>:<Password>
localhost:5432:*:postgres:mv!DEV99

-Deenkar

Hello!

I also have a problem to get rid of my old password for postpreqsl (didn´t even knew that I had one...). I have read a lot on this forum and other forums but I don´t manage to solve the problem.

I have tried this:

GO to Control Panel=> Administrative Tools=> Computer Management=> Local User and Groups and delete the postgres user from there and try installation after wards. It would be a success.

On my computer there are no "Local User and Groups" in the "Computer management". There are 3 maps (translated from swedish) called : "Systemtools", "Storage" and "Service and Programs". I don´t find anything that seems to connect to postpreqsl in any of this maps.

Someone who knows how to move on?

Best regards from Acid

Hi Acid,

If I am not wrong please expand the System Tools Menu for Local Users and Groups option.

Hi guys....

I had same problem just 10 min ago.

I solved it putting on password field: postgis. Again for confirm: postgis.

And installation gone success....

do not ask why or what...but important is the now run!

Byezz

This message was edited 1 time. Last update was at 25 Apr 2012 07:25:48

I too have issues with the install and have yet to have them resolved.

I used to develop databases using Visual Basic as a front end to an Oracle back end. Since moving away from that, I have wanted to go to my first preference which is using Visual C# as the front end to a PostgreSQL back end.

I am running Windows 7 64 Home Edition (which itself causes some of the issues I have discovered) with 8GB of RAM, dual core processor etc so I have enough grunt on this machine at least.

Initially I installed PostgreSQL along with the ODBC and ngpsql drivers. I also created two servers on this machine, one the normal Postgre server and the other the Enterprise edition. Both initially worked well even thought they weren't being recognised by the Application Stack Builder as being installed on my machine (but were there when running pgAdmin III, go figure).

The dramas arose when I tried to change the initial password. It was the default 'postgres' and I wanted to make it a touch more secure so I dug around and found that you (supposedly) could change the password which I dutifully did for both servers. The only problem then was that neither server recognised the new password nor would they recognise the old one. After much messing around I uninstalled Postgres and tried to reinstall it. I discovered then that the default postgres user in Users/User etc had to be removed as well - this wasn't discussed in the post that I was using. The only problem there being that with Win7 Home Edition, Users is not an item within Control Panel\Administrative Tools\Computer Management. To remove this I had to kill the folder within the Users folders and then go through the Registry as physically find all the references to Postgres and remove them. Once done, I thought that I had removed Postgres completely from my system.

Therefore, imagine my reaction when, upon reinstalling Postgres, it demanded a password which could only be 'postgres'. This left me with the assumption that all my efforts had been in vain and that there was still a vestige of Postgres on my system even after the efforts listed above or that the install will only let you use 'postgres' as the password and you can't change it after that. Either way it is not a very satisfactory solution.

Anyway, I reinstalled using that password and I can log onto the servers again and do all that back end admin work necessary to get a database up and running.

However, that doesn't solve my immediate problem which is to use Visual C# as the front end. The ngpsql driver is still not being recognised by Visual Studio even though I had to down grade my initial Visual Studio install from 2010 to 2008 as I found a post that stated that 2008 was the last version that would work with Postgres and ngpsql. The problem is that VS 2008 will still not make a reference using ngpsql.

My last option, before I go completely stir crazy, is to create a virtual Win7 box on this machine which I know will be untouched with any of the stupidities of the above and try again.

I am ready to go back to Oracle and use VS2010 as this experience with Postgres has left a rather sour taste in my mouth.

Hi,

How did you installed the ODBC and Npgsql drivers from StackBuilder if your stackbuilder dint recognize your servers? I assume you installed the PostgreSQL server using EnterpriseDB's One Click Installer.

On Windows there are 2 passwords,
i) The windows (Operating System) user 'postgres'. This user owns the 'postgresql-<version>' service.
ii) The database superuser 'postgres'. This is required when you try to log in to your database.

To change the password of (i) you can use 'Adminitrative Controls' -->Users option.
To change the password of (ii) you need to issue an ALTER ROLE sql query.

Even if you forgot the password of (ii) you can still change it by setting the authentication mode to trust in your pg_hba.conf and then changing the password as mentioned above and then resetting the authentication mode back.

Apparently, the uninstaller removes all instances of Postgres installed barring your data folder as it may contain user specific data and the user 'postgres' as we have no way to know that the user is being used by any other program.. (You get a proper message at the end of uninstallation).

Have you tried looking at this link for your Npgsql issue : http://npgsql.projects.postgresql.org/docs/manual/UserManual.html

I understand there are quite a hiccups when you try to learn a new thing. Please feel free to post your questions here, and I am sure somebody will help you out..