Re: Attention of all PostgreSQL 8.1.0-2 Windows Installer - Mailing list pgsql-ports

From Magnus Hagander
Subject Re: Attention of all PostgreSQL 8.1.0-2 Windows Installer
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE92E8E1@algol.sollentuna.se
Whole thread Raw
In response to Attention of all PostgreSQL 8.1.0-2 Windows Installer  (Ilias Goudaropoulos <ig@freemail.gr>)
List pgsql-ports
> I have to stress that I did not have any other software
> installed on windows at the moment and I had the Windows
> firewall service disabled.
>
> So I tried to install the new version 8.1.0-2 but got an
> error.  I tried at least 15 times and I always got the same
> error.  The error was manifesting itself during the
> installation as follows:

When this happened, did you get anything in the eventlog? Or in the
pg_log subdirectory of the instlalation?

These errors indicates a proper install where the server crashes after
install, and not a problem with the installer specifically.


> **************************************************************
>
> I uninstalled the 8.1.0-2 PostgreSQL which was not working
> and I tried to install again the 8.0.4, as someone in the
> novice mailing list suggested.  The 8.0.4 installer worked
> fine and I had PostgreSQL 8.0.4 up and running in no time.
>
> Then I uninstalled 8.0.4 and tried to install 8.1.0-2 for a
> last time.
> The same errors appeared once again.

Did you install it into the default directory, or a different one? Was
this directory completely empty when you started?
(This goes for both the base dir of the install and the data directory)

>
> After another suggestion from someone in the novice mailing
> list, I tried to reinstall the 8.0.4 and use the upgrade
> script of 8.1.0-2 to upgrade to the required version without
> using the installer. That worked fine and I had 8.1.0-2 up
> and running.

Uh, what upgrade script is that? There is no upgrade script from 8.0.4
to 8.1.0.

The proper upgrade path is:
1) pg_dump your old version
2) (optionally) uninstall the old version. At least stop it, or place
the two versions listening on different TCP ports.
3) Install the new vgersion
4) reload your dump from step 1 into the new version


Did you perform all these steps in order?


//Magnus

pgsql-ports by date:

Previous
From: Ilias Goudaropoulos
Date:
Subject: Attention of all PostgreSQL 8.1.0-2 Windows Installer
Next
From: Ilias Goudaropoulos
Date:
Subject: Re: Attention of all PostgreSQL 8.1.0-2 Windows Installer