Thread: Restoring Database from Data directory backup.

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.
I hope so or I am in shit.

On Jul 14, 12:57 pm, J Ottery <jott...@becsystems.com.au> 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.
> I hope so or I am in shit.

AS a follow up. The problem is I can no longer start the Postgres
Server (just says starting).

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