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: 46C98345.2070100@nexus.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Shane Ambler 2007-08-20 15:27:54 Re: Recovering databases
Previous Message Oliver Elphick 2007-08-20 11:35:20 Re: Recovering databases