when upgrading pg from 8.0 to 8.1 you will have to recreate your databases
and restore your data. the db files are not compatible. there is an easy
tutorial/explanation section in the documentation on "upgrading a db".
basically the steps are the following:
1. while having 8.0 running, dump your databases (pg_dump)
2. install & set-up 8.1
3. restore your databases (pg_restore) into 8.1
good luck,
thomas
----- Original Message -----
From: "Ilias Goudaropoulos" <ig@freemail.gr>
To: <pgsql-novice@postgresql.org>
Sent: Thursday, November 24, 2005 8:12 PM
Subject: Re: [NOVICE] Problem Upgrading from 8.0 to 8.1 (WinXP) ...not still
solved!!
>I have the same problem. I asked some other people I know of having the
>same problem, as well, and it seems that the do not know what to do. It is
>not a problem with firewalls or antiviruses that came about a lot lately
>regarding PostgreSQL 8.0xx.
>
> I have just reinstalled Windows XP SP2 from scratch, installed on it just
> PostgreSQL 8.0.4, created a database, uninstalled PostgreSQL 8.0.4,
> removed all garbage left by the unistaller in registry, tried to install
> the new PostgreSQL 8.1.0-2.
>
> That was the end of me. It produced the same errors you mention. Nothing
> I have tried can solve the problem. Only a clean Windows XP SP2
> reinstallation and an installation of PostgreSQL 8.1.0-2 straight from the
> beginning.
>
> It seems to me that the installer does not work well with Windows and
> leaves something behind that prohibits installation of the later version.
>
> Also when someone uninstalls the database the installer leaves the db user
> account -that was created during installation- intact, instead of deleting
> it. Why is that necessary?
>
> I think that the installer needs debugging or even redesign if it turns
> out that it is the problem.
>
> What is the point of PostgreSQL being the best free open source database
> if people can not even install it without reading through the mailing
> lists for weeks on end?
>
> Excuse me for my feelings but I am trying for weeks now to install the
> bloody thing and nothing seems to work.
>
> Also despite posting to the "novice" list, it seems that all users in this
> list are "Very Advanced" to be bothered answering me or "Info".
>
> What is a more serious Problem to you all? People not been able to even
> install the database or problems such as "Linux DB designer tools", "
> Large Objects in table ", " Application using PostgreSQL as a back end
> (experienced programmers please)" and the like?
>
> So much for novice or advanced users helping each other.
>
> ____________________________________________________________________
> http://www.freemail.gr - .
> http://www.freemail.gr - free email service for the Greek-speaking.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
