Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 73281634311 for ; Wed, 4 Mar 2009 16:24:45 -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 37884-02 for ; Wed, 4 Mar 2009 16:24:41 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail137135.authsmtp.net (outmail137135.authsmtp.net [62.13.137.135]) by mail.postgresql.org (Postfix) with ESMTP id 6F75463409A for ; Wed, 4 Mar 2009 16:24:40 -0400 (AST) Received: from mail-c187.authsmtp.com (mail-c187.authsmtp.com [62.13.128.33]) by punt6.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n24KObJt003629; Wed, 4 Mar 2009 20:24:37 GMT Received: from [192.168.0.3] (85-211-101-172.dyn.gotadsl.co.uk [85.211.101.172]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n24KOagb021360; Wed, 4 Mar 2009 20:24:37 GMT Subject: Re: Postgressql backup/restore question From: Simon Riggs To: Peter Eisentraut Cc: samana srikanth , pgsql-admin@postgresql.org In-Reply-To: <49AE8958.3070909@gmx.net> References: <49AE8958.3070909@gmx.net> Content-Type: text/plain Date: Wed, 04 Mar 2009 20:28:35 +0000 Message-Id: <1236198515.31880.108.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: 7b738914-08fa-11de-8156-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadRtFaAFbYFhD HGQLW11EUl17W2d/ aA0fZQBDYEtPQQRq UVZIRVBNFgBqBAMB SEAcVmINJlIUeHxx ZkBiEHFZW0c0chR6 QUZdFGkbZW82OX0e URQNagtVdQVXfh9E a1h6AHAKZjZWKBg1 TUcAFhwUHBNqYBxS WR0CN18JWl8PVjQ1 TBMfBXI1EFYZQD8+ ZwU7J0UAHUEXWicA X-Authentic-SMTP: 61633235383639.squirrel.dmpriest.net.uk:1378/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system. 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/49 X-Sequence-Number: 31549 On Wed, 2009-03-04 at 15:59 +0200, Peter Eisentraut wrote: > 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. It is possible, but we just don't currently support it. My submission on rmgr plugins would have provided this feature though it was rejected as "not wanted". I have code hooks required to do this, if people want to contact me off-list. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support