Re: Upgrading 8.0.2 to 8.0.3 on Windows XP

From: Frank Rittinger <gis(at)schnegg(dot)net>
To: "Giovanni M(dot)" <drayah(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Upgrading 8.0.2 to 8.0.3 on Windows XP
Date: 2005-08-15 07:04:34
Message-ID: 43003E82.8070104@schnegg.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-08-15 07:31:53 Re: Apostrophe doesn't show up in command line
Previous Message John Wells 2005-08-15 01:25:42 Re: Returns setof record PG/PLSQL