Re: restoring ver 7.2 database - Mailing list pgsql-general

From Richard Huxton
Subject Re: restoring ver 7.2 database
Date
Msg-id 200305061206.05992.dev@archonet.com
Whole thread Raw
In response to restoring ver 7.2 database  (Andrass Ziska Davidsen <c960334@student.dtu.dk>)
Responses Re: restoring ver 7.2 database
List pgsql-general
On Tuesday 06 May 2003 11:04 am, Andrass Ziska Davidsen wrote:
> I've really done it this time. I upgraded to Linux Mandrake 9.1. Now my
> pgsql version is 7.3. My database was version 7.2, and postmaster won't
> start.

Sorry, but ALWAYS dump/backup any databases before upgrading. And remember
that a simple file backup is useless unless you stop PG first and even then
won't transfer between versions (as you've found out).

> How can I restore my old data?
>
> install a local version 7.2 somewhere and tell it that the data lie on
> backuppoint?

Yep

> In order to do that I need the source files for v7.2, are they
> available somwhere?

Go to http://www.postgresql.org/ and click the download link near the top of
the page. Select a suitable mirror and look in pub/source/...
Installing from source isn't difficult, but make sure you read the
instructions before you do so.

--
  Richard Huxton


pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Cancelling a command.
Next
From: "Bjorn T Johansen"
Date:
Subject: What is the best practise for "autonumbering"..?