Re: Recovering databases - Mailing list pgsql-novice

From Peter Falk
Subject Re: Recovering databases
Date
Msg-id 46C98345.2070100@nexus.dk
Whole thread Raw
In response to Re: Recovering databases  (Oliver Elphick <olly@lfix.co.uk>)
Responses Re: Recovering databases  (Shane Ambler <pgsql@Sheeky.Biz>)
Re: Recovering databases  (Oliver Elphick <olly@lfix.co.uk>)
List 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

Regards
Peter


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
www.nexus.dk


pgsql-novice by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: Recovering databases
Next
From: Shane Ambler
Date:
Subject: Re: Recovering databases