Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 3A9F09FB1D2 for ; Thu, 18 Jan 2007 17:24:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 43249-01 for ; Thu, 18 Jan 2007 17:24:10 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 09FBF9FB228 for ; Thu, 18 Jan 2007 17:24:10 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from eciweb.eldocomp.com (eciweb.eldocomp.com [205.159.99.39]) by svr4.postgresql.org (Postfix) with ESMTP id 3B83D5AF985 for ; Thu, 18 Jan 2007 21:24:08 +0000 (GMT) Received: from ecimail.eldocomp.com [172.20.128.2] by eciweb.eldocomp.com with XWall v3.38 ; Thu, 18 Jan 2007 14:23:51 -0700 Received: from [127.0.0.1] ([172.20.131.10]) by ecimail.eldocomp.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 18 Jan 2007 14:23:50 -0700 References: <261CF9EEB14F5442894AB6DDA93AA6F44EDAD2@mail.siglercompanies.com> In-Reply-To: <261CF9EEB14F5442894AB6DDA93AA6F44EDAD2@mail.siglercompanies.com> From: Naomi Walker To: Jason Minion Cc: Yogvinder Singh , Shoaib Mir , "pgsql-admin@postgresql.org" Subject: Re: Incremental Backup of a particular database Date: Thu, 18 Jan 2007 14:23:49 -0700 X-Assembled-By: XWall v3.38 Message-ID: <45AFE565.4000804@eldocomp.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/159 X-Sequence-Number: 24315 I've been thinking about PITR. Since we have one production instance and one test instance of Postgres, in order to perform a PITR on any particular database would require reloading the entire instance onto another server, and extracting what I needed. Clunky, but do-able.=20