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 http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
Do you want to know God? http://www.lfix.co.uk/knowing_god.html
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 Seydioglu||Date: 2007-08-23 22:08:07|
|Subject: Truncate table|
|Previous:||From: Shane Ambler||Date: 2007-08-20 15:27:54|
|Subject: Re: Recovering databases|