| From: | Vibhor Kumar <vibhor(dot)aim(at)gmail(dot)com> |
|---|---|
| To: | Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com> |
| Cc: | Vibhor Kumar <vibhor(dot)aim(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Restore database after drop command |
| Date: | 2011-07-25 06:47:17 |
| Message-ID: | CA41459F-81E3-43EB-83B2-83362BB71858@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adarsh Sharma | 2011-07-25 07:11:05 | Re: Restore database after drop command |
| Previous Message | Adarsh Sharma | 2011-07-25 06:38:28 | Restore database after drop command |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sim Zacks | 2011-07-25 06:53:28 | Re: Implementing "thick"/"fat" databases |
| Previous Message | Christian Ullrich | 2011-07-25 06:45:00 | Re: Would it be possible |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adarsh Sharma | 2011-07-25 07:11:05 | Re: Restore database after drop command |
| Previous Message | Adarsh Sharma | 2011-07-25 06:38:28 | Restore database after drop command |