Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 85469632C4F for ; Fri, 8 May 2009 05:33:50 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 16773-10 for ; Fri, 8 May 2009 05:33:44 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wf-out-1314.google.com (wf-out-1314.google.com [209.85.200.175]) by mail.postgresql.org (Postfix) with ESMTP id 6DFFE6325DC for ; Fri, 8 May 2009 05:33:48 -0300 (ADT) Received: by wf-out-1314.google.com with SMTP id 28so1082721wfc.28 for ; Fri, 08 May 2009 01:33:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:from:to:references :in-reply-to:subject:date:message-id:mime-version:content-type :content-transfer-encoding:x-mailer:thread-index:content-language :x-cr-hashedpuzzle:x-cr-puzzleid; bh=t6Jgw+Xmtal3p7uuYDV5dVLaSCvcVkeRnG/obDxLzIM=; b=CMisUfY/3It0rtnOIG2BBKBLlIadjTmXgyw4H+/HamDHLB1CCbFyxGmI+Y6EthgVzT xMvjHuf1vqOAoVyVdULoKImgLgEa9Ko13rtdMnzHJD3SkqTLwp3HBBefvX48KYlnL/uh uLvxqZpV4W03qSkT9t8RlvrLIjuO3BZnbAalU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=from:to:references:in-reply-to:subject:date:message-id:mime-version :content-type:content-transfer-encoding:x-mailer:thread-index :content-language:x-cr-hashedpuzzle:x-cr-puzzleid; b=rb9VTCuvuh0vxw6e1WGDWX/N6Tjq4LCIXRlT1wsDq1ghsU9l32sQyzkvN5p2mzIKwC /gHqpYEKrSW8DYT99r+ljSa8hiY2d92g716ESCGwE5nHhgIaz3OS3ORmRgcs6fGEeVYV aLxZpqa+ETEJ/qZBrhiB6WizAf8RZdIxbCeJY= Received: by 10.142.177.13 with SMTP id z13mr1374142wfe.196.1241771627162; Fri, 08 May 2009 01:33:47 -0700 (PDT) Received: from BITDLLT03 ([122.160.72.188]) by mx.google.com with ESMTPS id 30sm2275381wff.29.2009.05.08.01.33.44 (version=SSLv3 cipher=RC4-MD5); Fri, 08 May 2009 01:33:46 -0700 (PDT) From: "Jyoti Seth" To: References: <4A03C276.9050007@postnewspapers.com.au> In-Reply-To: <4A03C276.9050007@postnewspapers.com.au> Subject: backup and restore Date: Fri, 8 May 2009 15:01:01 +0530 Message-ID: <004201c9cfbf$b6becab0$243c6010$@com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: AcnPnZHRVO2VHUFpT5Gemv3iYHIwwgAHioqQ Content-Language: en-us x-cr-hashedpuzzle: Atzo BfVB B64j Craa Cw2q C7Cg Dl4v FrI1 Gm4m G5LF HQNS HVPm HabM JHwh JpXF KDVK; 1; cABnAHMAcQBsAC0AcwBxAGwAQABwAG8AcwB0AGcAcgBlAHMAcQBsAC4AbwByAGcA; Sosha1_v1; 7; {03C1A565-A693-4B89-80E6-5A3B74C12C4F}; agB5AG8AdABpAHMAZQB0AGgAMgAwADAAMQBAAGcAbQBhAGkAbAAuAGMAbwBtAA==; Fri, 08 May 2009 09:30:55 GMT; YgBhAGMAawB1AHAAIABhAG4AZAAgAHIAZQBzAHQAbwByAGUA x-cr-puzzleid: {03C1A565-A693-4B89-80E6-5A3B74C12C4F} 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: 200905/19 X-Sequence-Number: 32511 Hello, I have two databases db1 and db2 with the same database structure on different systems with no network connection. In the first system with the db1 database user updates the master data. At the end of every day, the user needs to take the backup of updated data of master tables on db1 and update the data on another system with db2 database. We can't use WAL as in this as we want to take incremental backup of few tables only and can't use slony as there is no network connection between the systems. Please suggest some solution. Thanks, Jyoti