X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id DCE47D1B8DF for ; Tue, 19 Aug 2003 10:47:37 -0300 (ADT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 57457-07 for ; Tue, 19 Aug 2003 10:47:31 -0300 (ADT) Received: from bom6.vsnl.net.in (webmail2.vsnl.net [203.197.12.44]) by svr1.postgresql.org (Postfix) with ESMTP id 08CFFD1B8CD for ; Tue, 19 Aug 2003 10:47:26 -0300 (ADT) Received: from webmail2.vsnl.net (webmail2 [203.197.12.44]) by bom6.vsnl.net.in (Postfix) with ESMTP id 6E0C94FF78 for ; Tue, 19 Aug 2003 19:19:20 -0500 (GMT) Received: (from nobody@localhost) by webmail2.vsnl.net (8.11.7+Sun/8.11.7) id h7K0JJ503902 for pgsql-admin@postgresql.org; Tue, 19 Aug 2003 19:19:19 -0500 (GMT) Date: Tue, 19 Aug 2003 19:19:19 -0500 (GMT) Message-Id: <200308200019.h7K0JJ503902@webmail2.vsnl.net> X-Authentication-Warning: webmail2.vsnl.net: nobody set sender to theguardian@vsnl.net using -f Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: binary MIME-Version: 1.0 X-Mailer: MIME-tools 5.411 (Entity 5.404) From: theguardian@vsnl.net To: pgsql-admin@postgresql.org Subject: Incremental Backup X-Mailer: VSNL, Web based email X-Sender-Ip: 202.134.173.175 Cc: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/236 X-Sequence-Number: 9957 Resp. Sir /Madam, We are hosting a website who is having PostgreSQL RDBMS as back-end. In that we have to upload data onto the server from the standalone application on a daily basis. At present, on Standalone application side we are taking the backup of the whole database, While on the server side we are deleting, droping, creation of new tables and inserting the data into it. This is fine untill the data size is small, but it is increasing in abundant. So is there any way of doing some kind of incremental backup in which only the daily work which is done is backed up from the standalone machine and is appended into the data which is already existing over there on the server. The reply to this mail should be considered as an emergency case and i hope you cooperation for it. Thanks, Regards, The Guardian.