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

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

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

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-2017 The PostgreSQL Global Development Group