Postgres Pro
Downloads
Home   >   mailing lists

Re: Restore database after drop command - Mailing list pgsql-admin

From Vibhor Kumar
Subject Re: Restore database after drop command
Date
Msg-id CA41459F-81E3-43EB-83B2-83362BB71858@gmail.com
Whole thread Raw
In response to Restore database after drop command  (Adarsh Sharma <adarsh.sharma@orkash.com>)
Responses Re: Restore database after drop command  (Adarsh Sharma <adarsh.sharma@orkash.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Adarsh Sharma
Date:
Subject: Restore database after drop command
Next
From: Adarsh Sharma
Date:
Subject: Re: Restore database after drop command