Re: Upgrade in the wrong way

From: Andrew McMillan <Andrew(at)catalyst(dot)net(dot)nz>
To: ltito(at)voila(dot)fr
Cc: pgsql-novice(at)hub(dot)org
Subject: Re: Upgrade in the wrong way
Date: 2000-08-02 22:13:30
Message-ID: 39889D0A.2AC32D11@catalyst.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)cat-it(dot)co(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Patrick 2000-08-03 10:01:20 find empty holes in attribute (number) ?
Previous Message Anthony E . Greene 2000-08-02 14:03:51 Re: pgsql setup