Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 94EEB63491E for ; Wed, 4 Mar 2009 17:02:27 -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 78556-01 for ; Wed, 4 Mar 2009 17:02:24 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail128052.authsmtp.co.uk (outmail128052.authsmtp.co.uk [62.13.128.52]) by mail.postgresql.org (Postfix) with ESMTP id 6983A6350C3 for ; Wed, 4 Mar 2009 17:02:04 -0400 (AST) Received: from mail-c187.authsmtp.com (mail-c187.authsmtp.com [62.13.128.33]) by punt8.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n24L21nB095477; Wed, 4 Mar 2009 21:02:01 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 n24L1xph041570; Wed, 4 Mar 2009 21:01:59 GMT Subject: Re: Postgressql backup/restore question From: Simon Riggs To: Tom Lane Cc: Peter Eisentraut , samana srikanth , pgsql-admin@postgresql.org In-Reply-To: <6347.1236199034@sss.pgh.pa.us> References: <49AE8958.3070909@gmx.net> <1236198515.31880.108.camel@ebony.2ndQuadrant> <6347.1236199034@sss.pgh.pa.us> Content-Type: text/plain Date: Wed, 04 Mar 2009 21:05:57 +0000 Message-Id: <1236200757.31880.116.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: b45103e2-08ff-11de-8156-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksachtFaAFbYFhD HGQLW11EUlx7WWF/ awofZQBDYEtPQQRq UVZIRVBNFgBqBAMB SEAcVmVzP0UeeHpx YEFiEHFeWkI0J0J4 Q05XQG8bZW82Pn0e 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-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/55 X-Sequence-Number: 31555 On Wed, 2009-03-04 at 15:37 -0500, Tom Lane wrote: > Simon Riggs writes: > > 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. > > It's not as easy as all that. What will you do with updates to shared > catalogs? Apply them. So: its possible to do shared catalogs plus a subset of other databases. I was assuming that updates to shared catalogs were small overall. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support