From: Naomi Walker <nwalker@eldocomp.com>
To: pgsql-admin@postgresql.org
Subject: Re: pg_xlog
Date: Wed, 17 Dec 2008 19:40:42 -0700
Message-ID: <4949B82A.70502@eldocomp.com> (raw)
In-Reply-To: <4949AC74.4090103@eldocomp.com>
References: <4949AC74.4090103@eldocomp.com>
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@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: <4949B82A.70502@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