BUG #11399: CreateUser error when upgrading

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"

Responses

Browse pgsql-bugs by date

  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