From: Naomi Walker <nwalker@eldocomp.com>
To: pgsql-admin@postgresql.org
Subject: pg_xlog
Date: Wed, 17 Dec 2008 18:50:44 -0700
Message-ID: <4949AC74.4090103@eldocomp.com> (raw)
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@eldocomp.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
------------------------------------------------------------------------
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: nwalker@eldocomp.com
Subject: Re: pg_xlog
In-Reply-To: <4949AC74.4090103@eldocomp.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox