Restore filesystem backup - Mailing list pgsql-general

From Patrik Strömstedt
Subject Restore filesystem backup
Date
Msg-id C34282B910FD4CDDB092C62DA93E5A5C@shuttlexp
Whole thread Raw
Responses Re: Restore filesystem backup
List pgsql-general
Hi,
 
I have a big problem.
 
The backup (done nightly with pg_dump) at one of our customers sites is broken (well, it's overwritten and is of no use anymore). What is left is a filesystem backup that incudes the postgresql directories.
 
I'm trying to restore one of the tables from this "filesystem backup" (employee_pass (salaries..)), that has been deleted on the live system.
 
How (if possible), can I use this filesystem backup to restore the database into a working setup (off-site), from where I can retreive data from the one table (employee_pass).
 
This is on Windows 2000 Server, the Postgres version is 8.01 (I know, it's old...)
 
Patrik Strömstedt

pgsql-general by date:

Previous
From: Martin Gainty
Date:
Subject: Re: Possible limit on transaction size?
Next
From: Martin Gainty
Date:
Subject: Re: Getting rows in a very specific order