Skip site navigation (1) Skip section navigation (2)

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

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 (view raw, whole thread or download thread mbox)
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,

----- 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 

>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.
> ____________________________________________________________________
> -    .
> - 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

In response to

pgsql-novice by date

Next:From: Jaime CasanovaDate: 2005-11-24 19:49:24
Subject: Re: Schemas, databases, and backups
Previous:From: Ilias GoudaropoulosDate: 2005-11-24 19:12:02
Subject: Re: Problem Upgrading from 8.0 to 8.1 (WinXP) ...not still solved!!

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group