Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id EC517B5DC05 for ; Mon, 25 Jul 2011 04:47:02 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 53407-07 for ; Mon, 25 Jul 2011 07:46:56 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from www.postnewspapers.com.au (www.postnewspapers.com.au [173.230.139.50]) by mail.postgresql.org (Postfix) with ESMTP id E02AFB5DC03 for ; Mon, 25 Jul 2011 04:46:56 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by www.postnewspapers.com.au (Postfix) with ESMTP id 0142B10D; Mon, 25 Jul 2011 03:46:57 -0400 (EDT) X-Virus-Scanned: amavisd-new at postnewspapers.com.au.com Received: from www.postnewspapers.com.au ([127.0.0.1]) by localhost (www.postnewspapers.com.au [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 26KxmqQuUF5z; Mon, 25 Jul 2011 03:46:56 -0400 (EDT) Received: from mail.postnewspapers.com.au (ppp171-128.static.internode.on.net [150.101.171.128]) by www.postnewspapers.com.au (Postfix) with ESMTP id 32EAF37; Mon, 25 Jul 2011 03:46:56 -0400 (EDT) Received: from [10.0.0.53] (wallace.localnet [10.0.0.53]) by mail.postnewspapers.com.au (Postfix) with ESMTP id 2A8B3AF16C; Mon, 25 Jul 2011 15:46:55 +0800 (WST) Message-ID: <4E2D1F6F.1040203@postnewspapers.com.au> Date: Mon, 25 Jul 2011 15:46:55 +0800 From: Craig Ringer User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.15) Gecko/20110307 Thunderbird/3.1.9 MIME-Version: 1.0 To: Adarsh Sharma CC: pgsql-general General Subject: Re: [WAS:ADMIN] [WAS:PERFORM] Restore database after drop command References: <4E2D0F64.2040500@orkash.com> <4E2D1709.4020105@orkash.com> In-Reply-To: <4E2D1709.4020105@orkash.com> X-Enigmail-Version: 1.1.2 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-3.093 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RP_MATCHES_RCVD=-1.193 X-Spam-Level: X-Archive-Number: 201107/690 X-Sequence-Number: 178069 > [ADMIN] [PERFORM] First rule of mailing lists: DO NOT CROSS POST. Please stick to one mailing list. I've replied on pgsql-general where your post started out. Please do not reply to the posts on -admin or -perform. My reply follows below. On 25/07/11 15:11, Adarsh Sharma wrote: > I go through the link, so it is impossible to get the data back. > I have following files in my pg_xlog directory : > > 000000010000000700000091 > 000000010000000700000092 > 000000010000000700000093 > 000000010000000700000094 > 000000010000000700000095 > 000000010000000700000096 > 000000010000000700000097 > 000000010000000700000098 > > I think I issued the drop database command 1 month ago. .... and you're asking NOW? Even though "it's urgent"? The first rule of data recovery: As soon as you realize something is wrong, make a copy of everything immediately. Then stop using it. > > I think I issued the drop database command 1 month ago. > From the manual, I understand that my segment files are recycled to newer ones : Correct. Any chance you ever had of recovering your data is almost certainly gone because you restored into it - probably immediately destroying your deleted data - then kept on using the database for another month. If you're willing to spend a lot of money you might be able to recover some of it using hard-drive level overwritten data forensics, but I rather doubt it. -- Craig Ringer