Thread: Upgrade in the wrong way

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 ?

Thanks for any help

L. Tito de Morais
ltito@voila.fr

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