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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
