From: | kkaminski(at)vidsys(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #11399: CreateUser error when upgrading |
Date: | 2014-09-11 20:23:35 |
Message-ID: | 20140911202335.2488.89116@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 11399
Logged by: Kathy Kaminski
Email address: kkaminski(at)vidsys(dot)com
PostgreSQL version: 9.0.16
Operating system: Windows 2008 R2
Description:
I'm trying to install PostGres via InstallShield for our application as a
prerequisite. I noticed it won't let me upgrade from 9.0.13 to 9.0.16. I
see the following error:
Error running
C:\Users\Administrator\AppData\Local\Temp\2\postgresql_installer_d64e804b58\validateuser.exe
"." "postgres" "****" : Program ended with an error exit code
My InstallShield installer doesn't know the difference between new install &
upgrade (it doesn't need to, it just invokes the installer), I just pass the
same params to my prereq.
Now, if I try to net /delete my user account, then run the installer, then I
get an error that it won't let me use the password I used before (which is
odd because it will allow it on a fresh install). I changed the password,
ran through the install finally and THEN can't start the service because of
a permissions problem on the data directory!
I can't think of a way to work around this issue. Seems that the script
should be smart enough to know it's doing an upgrade and to ignore the user
params. I tried 9.0.16 & 9.0.18, but in 9.0.18 we can't run the 32 bit
installer because of another bug.
Here's what I'm passing for reference (passwords changed):
--unattendedmodeui none --mode unattended --superaccount postgres
--serviceaccount postgres --servicepassword password--superpassword
password--datadir "%SYSTEMDRIVE%\ProgramData\PostgreSQL\9.0\data"
From | Date | Subject | |
---|---|---|---|
Next Message | natan | 2014-09-11 21:27:06 | BUG #11401: When I comparison geting of field returns false, but when I do directly with result returns true |
Previous Message | kkaminski | 2014-09-11 20:15:20 | BUG #11398: FATAL error on install, permission denied |