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

Re: open db version 8.1 with postgresql version 8.2

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: open db version 8.1 with postgresql version 8.2
Date: 2007-05-25 12:14:17
Message-ID: 1180095257.12512.233.camel@linda.lfix.co.uk (view raw or flat)
Thread:
Lists: pgsql-novice
On Thu, 2007-05-24 at 22:47 -0400, Pedro A. Galvan wrote:
> Hi all
> 
> Could not find any reference to this kind of problem in the archives... (or 
> maybe I was not good at searching it... My apologies if so). Trying to update  
> from ubuntu 6.10 to 7.04, something went wrong  and botched up my posgresql 
> 8.1 server (would not start), among many other things.
> So I spent a month trying to figure it out, finally gave up. I did a fresh 
> install of Feisty Fawn, which includes postgresql 8.2. Now before that I was 
> able to back up the whole main directory for 8.1, but I was not able to do a 
> pg_dumpall. Now I have a working 8.2 installation and all my data backed up 
> in a 8.1 main directory.
> How can I load this into 8.2?
> 
> Thanks in advance for your kind help... 

Try installing 8.1 now:

sudo apt-get install postgresql-8.1


Ubuntu (being based on Debian) should allow you to run both versions at
once.  Once it is installed, make sure your old database is configured
as 8.1.  pg_lsclusters should show it; if not you will have to get it
configured right.  Then you should be able to pg_dump it, or even
upgrade it with pg_upgradecluster.



-- 
Oliver Elphick                                          olly(at)lfix(dot)co(dot)uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA  92C8 39E7 280E 3631 3F0E  1EC0 5664 7A2F A543 10EA
                 ========================================
   Do you want to know God?   http://www.lfix.co.uk/knowing_god.html


In response to

pgsql-novice by date

Next:From: sueDate: 2007-05-26 08:10:46
Subject: Error message: "error from Perl function"
Previous:From: Tom LaneDate: 2007-05-25 03:35:56
Subject: Re: open db version 8.1 with postgresql version 8.2

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