Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 090079FB947 for ; Tue, 13 Feb 2007 21:12:53 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 69918-08 for ; Tue, 13 Feb 2007 21:12:45 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id ABA6F9FB7BE for ; Tue, 13 Feb 2007 21:12:49 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l1E1CZmN001289; Tue, 13 Feb 2007 20:12:35 -0500 (EST) To: Zach Bagnall cc: pgsql-admin@postgresql.org, "Joshua D. Drake" , Peter Eisentraut , radhika@88thstreet.com Subject: Re: Postgresql Upgrade 7.4 to 8.2 In-reply-to: <45D23635.1070601@bulletinwireless.com> References: <21058.63.118.86.10.1169649336.squirrel@www.88thstreet.com> <200701241703.28901.peter_e@gmx.net> <45B79349.7050108@commandprompt.com> <45D23635.1070601@bulletinwireless.com> Comments: In-reply-to Zach Bagnall message dated "Wed, 14 Feb 2007 11:05:41 +1300" Date: Tue, 13 Feb 2007 20:12:35 -0500 Message-ID: <1288.1171415555@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.065 tagged_above=0 required=5 tests=AWL, BAYES_50, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200702/187 X-Sequence-Number: 24652 Zach Bagnall writes: >> Seriously though, the PITR recovery mechanism is quite mature and usable. > I would say it is a good start - and progress is clearly being made. But > it wont be "usable" for most serious applications until we have > per-database transaction logging and backup recovery. Don't hold your breath; that's not even on the agenda, much less something that's likely to appear soon. If you need separable recovery then run a different postmaster instance for each database. regards, tom lane