| From: | Patrik Strömstedt <patrik(at)digstud(dot)se> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Restore filesystem backup |
| Date: | 2008-09-13 13:07:23 |
| Message-ID: | C34282B910FD4CDDB092C62DA93E5A5C@shuttlexp |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martin Gainty | 2008-09-13 13:15:38 | Re: Possible limit on transaction size? |
| Previous Message | Merlin Moncure | 2008-09-13 11:41:05 | Re: Getting rows in a very specific order |