From: | <me(at)alternize(dot)com> |
---|---|
To: | "Ilias Goudaropoulos" <ig(at)freemail(dot)gr>, <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Problem Upgrading from 8.0 to 8.1 (WinXP) ...not still solved!! |
Date: | 2005-11-24 19:27:43 |
Message-ID: | 028401c5f12d$2461f8f0$0201a8c0@iwing |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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(at)freemail(dot)gr>
To: <pgsql-novice(at)postgresql(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jaime Casanova | 2005-11-24 19:49:24 | Re: Schemas, databases, and backups |
Previous Message | Ilias Goudaropoulos | 2005-11-24 19:12:02 | Re: Problem Upgrading from 8.0 to 8.1 (WinXP) ...not still solved!! |