Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 4BA4B9FB2FD for ; Thu, 18 Jan 2007 12:22:26 -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 97856-07 for ; Thu, 18 Jan 2007 12:22:18 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id 00F469FB2F6 for ; Thu, 18 Jan 2007 12:22:17 -0400 (AST) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Thu, 18 Jan 2007 16:22:15 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 18 Jan 2007 10:22:15 -0600 Subject: Re: Incremental Backup of a particular database From: Scott Marlowe To: Yogvinder Singh Cc: Shoaib Mir , pgsql-admin@postgresql.org In-Reply-To: <001101c73af3$0f0d43e0$0404a8c0@central.newgen.local> References: <001201c73a3e$33bbaf70$0404a8c0@central.newgen.local> <45AE370B.2070805@mailnetwork.co.uk> <000a01c73abf$863c45d0$0404a8c0@central.newgen.local> <009901c73ac5$d45de4c0$0404a8c0@central.newgen.local> <001101c73af3$0f0d43e0$0404a8c0@central.newgen.local> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1169137334.9586.81.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Thu, 18 Jan 2007 10:22:15 -0600 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/155 X-Sequence-Number: 24311 On Thu, 2007-01-18 at 05:23, Yogvinder Singh wrote: > So it means there is no way i can take incremental backup of one of > the databases from a postgresql database server?? Correct. You could replicate its tables to another server with slony and then use that to make incrementals with PITR. Maybe a better definition of what you're trying to do from a higher level would help.