From: Craig Ringer <craig@postnewspapers.com.au>
To: Adarsh Sharma <adarsh.sharma@orkash.com>
Cc: pgsql-general General <pgsql-general@postgresql.org>
Subject: Re: [WAS:ADMIN] [WAS:PERFORM] Restore database after drop command
Date: Mon, 25 Jul 2011 15:46:55 +0800
Message-ID: <4E2D1F6F.1040203@postnewspapers.com.au> (raw)
In-Reply-To: <4E2D1709.4020105@orkash.com>
References: <4E2D0F64.2040500@orkash.com>
<CA41459F-81E3-43EB-83B2-83362BB71858@gmail.com>
<4E2D1709.4020105@orkash.com>
> [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
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-performance@postgresql.org
Cc: craig@postnewspapers.com.au, adarsh.sharma@orkash.com, pgsql-general@postgresql.org
Subject: Re: [WAS:ADMIN] [WAS:PERFORM] Restore database after drop command
In-Reply-To: <4E2D1F6F.1040203@postnewspapers.com.au>
* 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