Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id B638065037A for ; Wed, 17 Dec 2008 22:10:15 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 08589-01 for ; Wed, 17 Dec 2008 22:10:12 -0400 (AST) X-Greylist: delayed 00:18:47.320461 by SQLgrey-1.7.6 Received: from fed1rmmtai111.cox.net (fed1rmmtai111.cox.net [68.230.241.49]) by mail.postgresql.org (Postfix) with ESMTP id 79555650360 for ; Wed, 17 Dec 2008 22:10:12 -0400 (AST) Received: from fed1rmimpo01.cox.net ([70.169.32.71]) by fed1rmmtao103.cox.net (InterMail vM.7.08.02.01 201-2186-121-102-20070209) with ESMTP id <20081218015053.LZEN12838.fed1rmmtao103.cox.net@fed1rmimpo01.cox.net> for ; Wed, 17 Dec 2008 20:50:53 -0500 Received: from [192.168.1.3] ([68.3.141.221]) by fed1rmimpo01.cox.net with bizsmtp id sRqs1a00G4moMiU03Rqsfm; Wed, 17 Dec 2008 20:50:52 -0500 X-Authority-Analysis: v=1.0 c=1 a=MMs69hwKY-V1X_WEhbQA:9 a=7n9kqATNHtHlKD-yluEA:7 a=upaIHG9AEabdd-FGpND9-mVjRyAA:4 a=6qQSkXpCXGcA:10 a=cymkAsTbCWcA:10 a=R2AIiUby1VoA:10 X-CM-Score: 0.00 Message-ID: <4949AC74.4090103@eldocomp.com> Date: Wed, 17 Dec 2008 18:50:44 -0700 From: Naomi Walker User-Agent: Thunderbird 2.0.0.18 (Windows/20081105) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: pg_xlog Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200812/136 X-Sequence-Number: 30969 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 ------------------------------------------------------------------------