I think i'll answer my own question, after. Since this is a write ahead
log, the only thing contained would be the "Drop Table"
statement. Since there are many databases in this instance, we would
have to restore the instance somewhere else, replaying
until just before the drop, then extract what we need.
Sigh.
Naomi
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@xxxxxxxxxxxx
---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
------------------------------------------------------------------------
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
