On 25/07/11 13:11, 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.
Did you make a copy of the database files as soon as you realized what
you had done?
If you did not, you can probably not recover the data because you have
kept using the database. It will have overwritten your deleted data with
other data by now.
> Today morning, I restore again the same database from backup (.sql) file.
Most likely you destroyed your old data by doing that.
> Please let me know if it is possible. It's urgent.
If it's also really important, stop using PostgreSQL RIGHT NOW. Shut it
down. Then call an expert who might be able to help you, if you're
really really lucky.
http://www.postgresql.org/support/professional_support