| 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: | Whole Thread | Raw Message | 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
| 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 |