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
Adarsh Sharma wrote:
> 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
* Adarsh Sharma wrote:
I have following files in my pg_xlog directory :
000100070091
[...]
000100070098
I think I issued the drop database command 1 month ago.
From the manual, I understand that my segment files are recycled to
newer ones :
PostgreSQL always writes
* Adarsh Sharma wrote:
In the evening, by mistake I issued a *drop database globedatabase* command.
Is it possible to get the data back till the state before drop database
command.
My pglog files is in the E:/data directory & Binary log is also enabled.
You do not mention that you have a f
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
