Upgrade of Windows MSI installations (version 8.0)

From: Adam Majer <adamm(at)zombino(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Upgrade of Windows MSI installations (version 8.0)
Date: 2006-04-21 14:00:17
Message-ID: 4448E571.3080009@zombino.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

This is in regards to the FAQ 3.7 "When upgrading the installer says I
don't have permissions to install a service, but I'm logged in as
administrator". To fix the problem, I did,

sc stop pgsql-8.0
sc delete pgsql-8.0
<RUN upgrade.bat here>

After the installation was completed, the service failed to start due to
incorrect login/password. To fix this small problem, go to the windows
regular service control and set proper login credentials. For example,
if your system account is different from postgres, you will need to
change it to the correct one (the owner of the data/* files) and also
set the password. Setting incorrect user name will cause the service to
start but fail (windows reports no error code) because PostgreSQL cannot
read the data directory.

Anyway, this is A LOT easier than reinstalling and I think it could be
added to the FAQ.

Also, I think this could be done in the installer. Windows could be
returning the permission error because the service already exists.

- Adam

PS. SC.EXE is a utility in Windows XP. You can also get it from
Microsoft at ftp://ftp.microsoft.com/reskit/win2000/sc.zip

Browse pgsql-general by date

  From Date Subject
Next Message Teodor Sigaev 2006-04-21 14:07:13 Re: A few questions about ltree
Previous Message Teodor Sigaev 2006-04-21 13:55:05 Re: GiST index slower than seqscan