Hello Giovanni,
I had a similar problem. I think the windows installer tries to create
a new service which he can't, since there is already one with the same
name. I uninstalled Postgresql but told it to keep the data directory,
rebooted the machine (that's important since only then the old service
is removed) and installed the new version, using the old data directory.
However, I would still do a dump before :-)
Hope this helps, Frank
Giovanni M. wrote:
Hello,
Wondering if somebody can help me out with upgrading a PostgreSQL 8.0.2
installation on Windows XP SP2.
I can´t seem to upgrade to 8.0.3 on a Windows XP Machine. The machine
has a limited user account running the pgsql-8.0 service. The first
installation was performed succesfully with the win32 installer.
A subsequent upgrade using the upgrade.bat file from the postgresql8.0.3
win32 distribution hangs at the very end with the following isntallation
error: "Verify
that you have sufficient privileges to start system services"... I must
cancel the installation at this point and it automatically performs a
rollback.
I cant seem to figure out why this keeps happening. I´m doing the
upgrade from an administrator account with all privileges, the limited
user account which runs the pgsql service has log on as service rights...
Anybody know a solution to this, or do I simply need to dump my
database, uninstall 8.0.2, do a fresh install of 8.0.3 and reload my
database?
Thanks in advance,
gio
--
A World of KEIGI
http://keigi.blogspot.com
--
Frank Rittinger
TERRAPLAN Geographische Informationssysteme
Gewerbestr. 33
79227 Schallstadt
Germany
Tel.: 07664-505315
Fax.: 07664-505321
http://www.terraplan.com
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend