Re: Recovering databases

[Peter Falk <peter(at)nexus(dot)dk>]

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