Re: Restoring Database from Data directory backup. - Mailing list pgsql-general

From Klint Gore
Subject Re: Restoring Database from Data directory backup.
Date
Msg-id 487AD8D1.70700@une.edu.au
Whole thread Raw
In response to Restoring Database from Data directory backup.  (J Ottery <jottery@becsystems.com.au>)
List pgsql-general
J Ottery wrote:
> Using XP Pro and Postgres 8.3
> I made a backup of the "Data" directory of the Postgres Installation
> to another place on the hard disk.
> Now the customer has uninstalled postgres then reinstalled a new one.
> Of course the original tables are all gone.
> Is there a method of retrieving the original tables and data from the
> backedup Data directory.
>
>
If you can get the same version that they used to have you, should be
able to start it on the same platform.  Look for the PG_VERSION file in
the data directory.

Download from http://www.postgresql.org/ftp/binary/

I'm assuming that your backup took the entire directory tree under data
and postgres wasn't running when you did it?

klint.

--
Klint Gore
Database Manager
Sheep CRC
A.G.B.U.
University of New England
Armidale NSW 2350

Ph: 02 6773 3789
Fax: 02 6773 3266
EMail: kgore4@une.edu.au


pgsql-general by date:

Previous
From: Shane Ambler
Date:
Subject: Re: Requirements For Postgresql Database
Next
From: Klint Gore
Date:
Subject: Re: Top N within groups?