Re: Upgrade in the wrong way - Mailing list pgsql-novice

From Andrew McMillan
Subject Re: Upgrade in the wrong way
Date
Msg-id 39889D0A.2AC32D11@catalyst.net.nz
Whole thread Raw
In response to Upgrade in the wrong way  ("Luis Tito de Morais" <ltito@voila.fr>)
List pgsql-novice
Luis Tito de Morais wrote:
>
> Hi,
>
> As a newbie to Postgres, I made a complete backup of my databases on a
> cdrom when I left my previous office. I did not use pg_dump. I was
> runing Version 6.5.3.
>
> I am now on a computer running Postgresql7.0
>
> Of course I am in trouble.
>
> Is there anyway to dump my old base to recover it in the 7.0 version
> without installing the 6.5 complete version ?

You should be able to unpack a 6.5 package and get out the necessary
files to dump and restore your database.

The Debian packages do this very nicely - when you upgrade from version
X to Y they save the binaries necessary to dump your database, rather
than overwriting them.

All is very far from lost :-)

Cheers,
                    Andrew.
--
_____________________________________________________________________
            Andrew McMillan, e-mail: Andrew@cat-it.co.nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267

pgsql-novice by date:

Previous
From: "Anthony E . Greene"
Date:
Subject: Re: pgsql setup
Next
From: Patrick
Date:
Subject: find empty holes in attribute (number) ?