Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 7BBD76328C9 for ; Thu, 1 Oct 2009 03:37:25 -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 97836-02 for ; Thu, 1 Oct 2009 06:37:12 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-iw0-f175.google.com (mail-iw0-f175.google.com [209.85.223.175]) by mail.postgresql.org (Postfix) with ESMTP id B892B63283E for ; Thu, 1 Oct 2009 03:37:14 -0300 (ADT) Received: by iwn5 with SMTP id 5so3860413iwn.15 for ; Wed, 30 Sep 2009 23:37:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type; bh=tL7X/MlFbSawbyVeT8kccfxgWOeygSv33wjcTBDwzeA=; b=pVWilBMXt8ewZcA6eB+FFqboaDOxrCdGW1JSS+I2tfp5K8ds16cn5U4PLLpoP/p+N7 sOgWccvcjD0u5njuDQdHCq6JKm19/tHdTbJ0sUMZVR+jlfireld3EHY/w6EtKUYBvPJc 69iThf210CONsBoKfvV1qSNAUn/MdtJJPp4/M= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=glWrb5FPkbuvSSvV7VMlttgKcfvTJCh69fjdaGiBnoiHRBuN3nyFVla5AL2GDMi1ZZ uycnJQGsS/XA9/DoiF8zYpeloq9HeAD5HICgQZ94ILJT3JNF8MBiyVRNV5OWqxgsvsgc DqlwJMraiB5yr96A52AVLmkDmXzARxKIwfmbw= MIME-Version: 1.0 Received: by 10.231.26.131 with SMTP id e3mr1636128ibc.0.1254379033245; Wed, 30 Sep 2009 23:37:13 -0700 (PDT) In-Reply-To: <25693180.post@talk.nabble.com> References: <25693180.post@talk.nabble.com> Date: Thu, 1 Oct 2009 00:37:13 -0600 Message-ID: Subject: Re: Pg_Restore with --clean option From: Scott Marlowe To: Jyoti Seth Cc: pgsql-sql@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.468 tagged_above=-10 required=5 tests=AWL=0.131, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200910/5 X-Sequence-Number: 33204 On Wed, Sep 30, 2009 at 11:14 PM, Jyoti Seth wrote: > > I want to restore data of a single table. Before restoring the data I > disabled all the triggers and constraints on that table. I used the restore > command with --clean option so that data gets deleted from that table and > then fresh data get inserted. You could run truncate on the table then just restore its data from the other machine. If you still get dups then there's dups in the original data.