Re: Problem Upgrading from 8.0 to 8.1 (WinXP) ...not still solved!!

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
>