Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 06886632AFB for ; Tue, 9 Jun 2009 06:39:02 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 36501-09 for ; Tue, 9 Jun 2009 06:39:00 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.227]) by mail.postgresql.org (Postfix) with ESMTP id D2F6B632AD1 for ; Tue, 9 Jun 2009 06:39:00 -0300 (ADT) Received: by rv-out-0506.google.com with SMTP id k40so1711977rvb.43 for ; Tue, 09 Jun 2009 02:38:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:from:to:subject:date :message-id:mime-version:content-type:x-mailer:thread-index :content-language; bh=9AJnTk9QKr+ytQ4ofTxVEo77q2bs+I8kKKoBSZ2c1M0=; b=ikIe80b0bI1WFLHV60CcL8IdpC7oddwilU+gzQpVM3Des/7c0gxmSFFRK072S/QHLd Eh7f74BdFXw5/8ypFdQ0GHq8oSxpbAj7tO7Gh8sdpHm1eceFLQygLR61RSw1J1Q9Yuc+ OFM0ePS2LRYqswCJbZ6gEyNGpyjzoshZaCJ+g= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=from:to:subject:date:message-id:mime-version:content-type:x-mailer :thread-index:content-language; b=DcES7eRwa5QCSALZfh6W0c9GCP4Ca93vveNjB4Cpte5A77vgKA5p6DpB17TaG3WuI1 qh6uhCWRU9RPZSOp6bdxd1ciW5HqAER9yfWh61J4rjNXQMWRuZKOAN00enPFWrkOw4Ye oQAGrjElnosc1nNdA/wMnl3PyfPxTDqpT1vH4= Received: by 10.142.237.19 with SMTP id k19mr2613697wfh.68.1244540339056; Tue, 09 Jun 2009 02:38:59 -0700 (PDT) Received: from BITDLLT03 ([122.160.72.188]) by mx.google.com with ESMTPS id 22sm2039986wfi.32.2009.06.09.02.38.56 (version=SSLv3 cipher=RC4-MD5); Tue, 09 Jun 2009 02:38:58 -0700 (PDT) From: "Jyoti Seth" To: Subject: pg_restore Date: Tue, 9 Jun 2009 15:02:05 +0530 Message-ID: <003101c9e8e5$2a31ee80$7e95cb80$@com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0032_01C9E913.43EA2A80" X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: AcnlyKRUxTX4IuYqROug4updZ56TSQDGr5mg Content-Language: en-us X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200906/36 X-Sequence-Number: 32641 This is a multipart message in MIME format. ------=_NextPart_000_0032_01C9E913.43EA2A80 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi all, I have two databases db1 and db2 with no network connection. I want to take backup of few master tables from db1 and restore it to db2 at frequent intervals.. I do not want to delete data from the tables and restores the fresh data as this data is getting referenced in other tables. I can do that by creating scripts on db1 and executing the same on db2. But I want to know if I can use pg_restore command to overwrite existing data of these master tables Thanks, Jyoti ------=_NextPart_000_0032_01C9E913.43EA2A80 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi all,

I have two databases db1 and db2 with no network connection. I want to take backup of few master tables from db1 and = restore it to db2 at frequent intervals.. I do not want to delete data from the = tables and restores the fresh data as this data is getting referenced in other = tables. I can do that by creating scripts on db1 and executing the same on db2. = But I want to know if I can use pg_restore command to overwrite existing = data of these master tables

Thanks,

Jyoti

------=_NextPart_000_0032_01C9E913.43EA2A80--