Message-ID: <4949B82A.70502@eldocomp.com>
Date: Wed, 17 Dec 2008 19:40:42 -0700
From: Naomi Walker <nwalker@eldocomp.com>
User-Agent: Thunderbird 2.0.0.18 (Windows/20081105)
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: pg_xlog
References: <4949AC74.4090103@eldocomp.com>
In-Reply-To: <4949AC74.4090103@eldocomp.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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
------------------------------------------------------------------------