Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 76998B5D80A
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon, 25 Jul 2011 03:38:31 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 82456-08 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon, 25 Jul 2011 06:38:25 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from smtp192.dfw.emailsrvr.com (smtp192.dfw.emailsrvr.com
	[67.192.241.192])
	by mail.postgresql.org (Postfix) with ESMTP id 37E7CB5D91F
	for <pgsql-admin@postgresql.org>; Mon, 25 Jul 2011 03:38:24 -0300 (ADT)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by smtp9.relay.dfw1a.emailsrvr.com (SMTP Server) with ESMTP id
	830C13C0159; Mon, 25 Jul 2011 02:38:23 -0400 (EDT)
X-Virus-Scanned: OK
Received: by smtp9.relay.dfw1a.emailsrvr.com (Authenticated sender:
	adarsh.sharma-AT-orkash.com) with ESMTPSA id 9B28D3C0157;
	Mon, 25 Jul 2011 02:38:22 -0400 (EDT)
Message-ID: <4E2D0F64.2040500@orkash.com>
Date: Mon, 25 Jul 2011 12:08:28 +0530
From: Adarsh Sharma <adarsh.sharma@orkash.com>
User-Agent: Thunderbird 2.0.0.22 (X11/20090625)
MIME-Version: 1.0
To: pgsql-admin@postgresql.org, pgsql-performance@postgresql.org
Subject: Restore database after drop command
Content-Type: multipart/alternative;
	boundary="------------090107000908070602060908"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201107/179
X-Sequence-Number: 37958

This is a multi-part message in MIME format.
--------------090107000908070602060908
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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 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.

My pglog files is in the E:/data directory & Binary log is also enabled.

Please let me know if it is possible. It's urgent.


Thanks & Regards
Adarsh Sharma

--------------090107000908070602060908
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
Dear all,<br>
<br>
I am using Postgres-8.4.2 on Windows system.<br>
I have 2 databases in my postgres database ( globedatabase (21GB),
urldatabase).<br>
<br>
I restore globedatabase from a .sql file on yesterday morning.I insert
some new data in that database.<br>
In the evening, by mistake I issued a <b>drop database globedatabase</b>
command.<br>
<br>
Today morning, I restore again the same database from backup (.sql)
file.<br>
My .sql file have data till yesterday morning but I want newly insert
data now. Is it possible.<br>
<br>
Is it possible to get the data back till the state before drop database
command.<br>
<br>
My pglog files is in the E:/data directory &amp; Binary log is also
enabled.<br>
<br>
Please let me know if it is possible. It's urgent.<br>
<br>
<br>
Thanks &amp; Regards<br>
Adarsh Sharma
</body>
</html>

--------------090107000908070602060908--