Re: restoring ver 7.2 database

From: Richard Huxton <dev(at)archonet(dot)com>
To: Andrass Ziska Davidsen <c960334(at)student(dot)dtu(dot)dk>, pgsql-general(at)postgresql(dot)org
Subject: Re: restoring ver 7.2 database
Date: 2003-05-06 11:06:05
Message-ID: 200305061206.05992.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bjorn T Johansen 2003-05-06 11:09:13 What is the best practise for "autonumbering"..?
Previous Message Richard Huxton 2003-05-06 11:01:15 Re: Cancelling a command.