From: Adarsh Sharma <adarsh.sharma@orkash.com>
To: Vibhor Kumar <vibhor.aim@gmail.com>
Cc: pgsql-admin@postgresql.org
Cc: pgsql-performance@postgresql.org
Subject: Re: Restore database after drop command
Date: Mon, 25 Jul 2011 12:41:05 +0530
Message-ID: <4E2D1709.4020105@orkash.com> (raw)
In-Reply-To: <CA41459F-81E3-43EB-83B2-83362BB71858@gmail.com>
References: <4E2D0F64.2040500@orkash.com>
<CA41459F-81E3-43EB-83B2-83362BB71858@gmail.com>
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.
From the manual, I understand that my segment files are recycled to
newer ones :
/The segment files are given numeric names that reflect their position
in the abstract WAL sequence. When not using WAL archiving, the system
normally creates just a few segment files and then "recycles" them by
renaming no-longer-needed segment files to higher segment numbers. It's
assumed that a segment file whose contents precede the
checkpoint-before-last is no longer of interest and can be recycled.
/My archive_status folder is empty.
How would we know that which data these segment files corresponds too.
I followed below steps 1 month ago :
1. Load globdatabase through backup.sql (21 GB)file
2. Insert some data near about 3-4 tables ( KB) data.
3. Drop database globdatabase.
4. Load globdatabase through backup.sql (21GB)file
May be there is chance because we work very rarely on that system.
Now i have the backup file bt I want that 3-4 tables.
Thanks
Vibhor Kumar wrote:
> On Jul 25, 2011, at 12:08 PM, Adarsh Sharma wrote:
>
>
>> I restore globedatabase from a .sql file on yesterday morning.I insert some new data in that database.
>> In the evening, by mistake I issued a drop database globedatabase command.
>> Today morning, I restore again the same database from backup (.sql) file.
>> My .sql file have data till yesterday morning but I want newly insert data now. Is it possible.
>> Is it possible to get the data back till the state before drop database command.
>>
>
> No you won't be able to recover.
>
> If you have Online Backup, then PITR would help you.
>
> Thanks & Regards,
> Vibhor Kumar
> Blogs: http://vibhork.blogspot.com
> http://vibhorkumar.wordpress.com
>
>
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: adarsh.sharma@orkash.com, vibhor.aim@gmail.com, pgsql-admin@postgresql.org
Subject: Re: Restore database after drop command
In-Reply-To: <4E2D1709.4020105@orkash.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