Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id AA140632427 for ; Wed, 4 Mar 2009 10:00:21 -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 34858-05 for ; Wed, 4 Mar 2009 10:00:01 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by mail.postgresql.org (Postfix) with SMTP id 3D8AE62DCFD for ; Wed, 4 Mar 2009 09:59:59 -0400 (AST) Received: (qmail invoked by alias); 04 Mar 2009 13:59:58 -0000 Received: from gmp-ea-fw-1.sun.com (EHLO dhcp-eesp05-101-128.Finland.Sun.COM) [192.18.1.36] by mail.gmx.net (mp011) with SMTP; 04 Mar 2009 14:59:58 +0100 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX18yQ/IdVU8y/2k+Xo+1pPWB6iT5i959mWx8ST2saZ dARRuP2ieY6qBi Message-ID: <49AE8958.3070909@gmx.net> Date: Wed, 04 Mar 2009 15:59:52 +0200 From: Peter Eisentraut User-Agent: Thunderbird 2.0.0.19 (Macintosh/20081209) MIME-Version: 1.0 To: samana srikanth CC: pgsql-admin@postgresql.org Subject: Re: Postgressql backup/restore question References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-FuHaFi: 0.8100000000000001 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/40 X-Sequence-Number: 31540 samana srikanth wrote: > Can we do a point-in-time restore of a single database out of n > databases??. In principle no. But you could invent workarounds such as recovering to the point where you are happy with your restored one database, and then restore the other n-1 databases from an SQL dump.