Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 880A0633EAC
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed,  4 Mar 2009 07:56:39 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 97858-08 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed,  4 Mar 2009 07:56:35 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-fx0-f168.google.com (mail-fx0-f168.google.com
	[209.85.220.168])
	by mail.postgresql.org (Postfix) with ESMTP id B5E61633DDF
	for <pgsql-admin@postgresql.org>; Wed,  4 Mar 2009 07:56:35 -0400 (AST)
Received: by fxm12 with SMTP id 12so3891002fxm.19
	for <pgsql-admin@postgresql.org>; Wed, 04 Mar 2009 03:56:33 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:date:message-id:subject
	:from:to:content-type;
	bh=tP+osm2OhEkISvQ/w8iHgamh+cGIuJKGDKMipF7bguA=;
	b=mCBlIuLbP9D6QdL1qONrkw0VPBHs/6EZiCmQUE1m4KeFaQUEQyYSrHeiPgohOu/ur2
	oQy0mS2L35NDrnV2KSn4T3i9aC8yEJfXlbzAk4c72OZmXn671jEuM6frNvCwFvZ2ijy5
	8UiHb0YSZAS2hbkbCE/MPK+d/9c08BdQzhlrs=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type;
	b=JE3xSQWFDzDMJ6NIJCrxoh5wE/HQPSqmrnQLy39P1aoQNFIID2PpB9POsHG3/xYPNc
	yqi7ztiXPEMeR3vP/onaglOxNl6XrNNcyyTmjBmQ+F3Mor2/kgOkv2U3xQE+YfiIncAA
	jy2CUBXZUJjZlarngTk4z7tlXyGAzIVZZjBWU=
MIME-Version: 1.0
Received: by 10.103.192.2 with SMTP id u2mr4140975mup.2.1236167793006;
 Wed, 04
	Mar 2009 03:56:33 -0800 (PST)
Date: Wed, 4 Mar 2009 17:26:32 +0530
Message-ID: <e42828680903040356o307031c2k7898562d8e2d275c@mail.gmail.com>
Subject: Postgressql backup/restore question
From: samana srikanth <samanasrikanth@gmail.com>
To: pgsql-admin@postgresql.org
Content-Type: multipart/alternative; boundary=001636a7dabf2f58a4046449beff
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200903/39
X-Sequence-Number: 31539

--001636a7dabf2f58a4046449beff
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Hi all

Can we do a point-in-time restore of a single database out of n databases??.
------------------------------------------------------------------------------------------------------------------------------------------
I have 5 databases in the postgresql server.

I have taken full-backup of the entire data directory (/opt/postgresql/data)
and individual dumps also (for safety).
then i have taken all the log files till now.
Now, the server is crashed.

Is there anyway to restore only 1 database out of total 5 database to
particular point-in-time. (similar to Mysql)

I have individual dumps of each database and all corresponding log files
from that time.
Can i selectively restore the databases.

Can I use dump files + log files to restore the databases.
---------------------------------------------------------------------------------------------------------------------------------------------

Please help me in this regards


Thanks
Srikanth

--001636a7dabf2f58a4046449beff
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi all<div><br></div><blockquote class=3D"webkit-indent-blockquote" style=
=3D"margin: 0 0 0 40px; border: none; padding: 0px;">Can we do a point-in-t=
ime restore of a single database out of n databases??.<br>-----------------=
---------------------------------------------------------------------------=
----------------------------------------------<br>
I have 5 databases in the postgresql server.<br><br>I have taken full-backu=
p of the entire data directory (/opt/postgresql/data) and individual dumps =
also (for safety).<br>then i have taken all the log files till now.<br>
Now, the server is crashed.<br><br>Is there anyway to restore only 1 databa=
se out of total 5 database to particular point-in-time. (similar to Mysql)<=
br><br>I have individual dumps of each database and all corresponding log f=
iles from that time.<br>
Can i selectively restore the databases.<br><br>Can I use dump files + log =
files to restore the databases.<br>----------------------------------------=
---------------------------------------------------------------------------=
--------------------------<br>
<br>Please help me in this regards<br></blockquote><div><br></div><div>Than=
ks</div><div>Srikanth</div>

--001636a7dabf2f58a4046449beff--