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

Re: Recovering databases

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: Peter Falk <peter(at)nexus(dot)dk>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Recovering databases
Date: 2007-08-20 16:50:17
Message-ID: 1187628617.11632.138.camel@linda.lfix.co.uk (view raw or flat)
Thread:
Lists: pgsql-novice
On Mon, 2007-08-20 at 14:04 +0200, Peter Falk wrote:
> The installation is Debian Sarge (3.1). I did a complete update, but 
> during this I got the information, that Postgresql has to be upgraded 
> separately - can't remember the exact words.
> 
> I did this update and to my suprise it installed a version 7.4. Then i 
> removed this installation and installed a version 8.1. Afterwards I 
> cheched to see the packages installed and recognized, that some 
> 7.4-packages still resided om the server.
> 
> I there upon (and this is when the big mistake occured) decided to 
> remove all PG-packages and do a clean install.
> The misson succeded but the patient died!
> 
> At this moment I got a runing PG but without connecion to the old 
> databases. The database-files still resides on the server, but I can't 
> get PG to recognize them.
> 
> I think that the PG-installation prior to the mistake was v. 8.0 - I 
> know for sure that it was newer than 7.x

In that case you should install postgresql-8.0 and
postgresql-client-8.0.  That should enable you  to get access to your
8.0 database.  Unfortunately, they aren't available from the Debian
archive, although they were available in testing for a while before 8.1
came out.  They should still exist somewhere on the web.

What puzzles me though is that you are/were running Sarge.  The latest
version of postgresql in Sarge is 7.4 (and the current stable release of
Debian is Etch, which has PostgreSQL 8.1).  "Doing a complete update"
will presumably have upgraded you to Etch.  In Sarge, the postgresql
packages were of version 7.4 but 7.4 did not appear in their names; the
fact that the upgrade to Etch installed *-7.4 packages suggests to me
that you were in fact running 7.4 in Sarge, because the *-7.4 packages
would have been needed to achieve a smooth upgrade.  (The postgresql
package in Etch is a transitional package that depends on
postgresql-7.4.)

To check on the version you want, check the contents of the file
PG_VERSION in the database directory.  If you are right, it should say
8.0

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


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.


In response to

pgsql-novice by date

Next:From: Burak SeydiogluDate: 2007-08-23 22:08:07
Subject: Truncate table
Previous:From: Shane AmblerDate: 2007-08-20 15:27:54
Subject: Re: Recovering databases

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