| From: | Naomi Walker <nwalker(at)eldocomp(dot)com> | 
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org | 
| Subject: | pg_xlog | 
| Date: | 2008-12-18 01:50:44 | 
| Message-ID: | 4949AC74.4090103@eldocomp.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-admin | 
Everyone,
-
The guys on one of our servers deleted a table and need the data from 
it.  Somehow, our backup job did not run.
 We have the pg_xlog that should (may) contain the deleted data.  We 
need to know if there is a way to extract the
records that were deleted from the file and write them back into the 
table.  Is there a way to retrieve the data from
the pg_xlog?
This is a server running x86 Solaris 10, postgres 8.2.4.
Naomi
-- 
------------------------------------------------------------------------
Naomi Walker                          Chief Information Officer
Eldorado Computing, Inc               nwalker(at)eldocomp(dot)com
  ---An EDS Company                   602-604-3100
------------------------------------------------------------------------
Hard things are put in our way, not to stop us, but to call out our
courage and strength. -- Anonymous
------------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Naomi Walker | 2008-12-18 02:40:42 | Re: pg_xlog | 
| Previous Message | Michael Monnerie | 2008-12-17 22:09:54 | DROP INDEX causes errors |