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

Re: Recovering databases

From: Peter Falk <peter(at)nexus(dot)dk>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Recovering databases
Date: 2007-08-20 12:04:21
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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


Oliver Elphick skrev:
> On Mon, 2007-08-20 at 10:35 +0200, Peter Falk wrote:
>> Hi,
>> I did some updating on my Linux server and was a bit too efficient. 
>> Databases on the server prior to the update is no longer reachable from 
>> pgsql all though still present on the server. Of course I didn't do a 
>> pg_dump before the update!!!
> What precisely did you update?  What are the versions involved?  Is this
> a package installation (Red Hat/Debian/etc)? or did you build from
> source?

Med venlig hilsen
Peter Falk
Nexus Kommunikation
Ă˜stre Messegade 2
2650 Hvidovre
36 77 00 46

In response to


pgsql-novice by date

Next:From: Shane AmblerDate: 2007-08-20 15:27:54
Subject: Re: Recovering databases
Previous:From: Oliver ElphickDate: 2007-08-20 11:35:20
Subject: Re: Recovering databases

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