Re: Restoring Database from Data directory backup.

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