Re: [ADMIN] Restore database after drop command

2011-07-25 Thread Florian Weimer
* Adarsh Sharma: > 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 ha

Re: [ADMIN] Restore database after drop command

2011-07-25 Thread Adarsh Sharma
I go through the link, so it is impossible to get the data back. I have following files in my pg_xlog directory : 000100070091 000100070092 000100070093 000100070094 000100070095 000100070096 000100070097 0001

Re: [ADMIN] Restore database after drop command

2011-07-24 Thread Vibhor Kumar
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 backu

[ADMIN] Restore database after drop command

2011-07-24 Thread Adarsh Sharma
Dear all, I am using Postgres-8.4.2 on Windows system. I have 2 databases in my postgres database ( globedatabase (21GB), urldatabase). 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