X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A6B4FD1B199 for ; Wed, 23 Jun 2004 14:25:15 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 40356-06 for ; Wed, 23 Jun 2004 17:25:15 +0000 (GMT) Received: from sj-iport-4.cisco.com (sj-iport-4.cisco.com [171.68.10.86]) by svr1.postgresql.org (Postfix) with ESMTP id 429B8D1B27A for ; Wed, 23 Jun 2004 14:25:12 -0300 (ADT) X-BrightmailFiltered: true Received: from cjwhitew2k02 (dhcp-128-107-147-47.cisco.com [128.107.147.47]) by sj-core-3.cisco.com (8.12.10/8.12.6) with ESMTP id i5NHBkRs013973 for ; Wed, 23 Jun 2004 10:11:46 -0700 (PDT) Reply-To: From: "Chris White (cjwhite)" To: Subject: Problems restoring tables using 7.4.2 Date: Wed, 23 Jun 2004 10:11:45 -0700 Message-ID: <027801c45945$29dd7010$0200a8c0@amer.cisco.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.4024 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/313 X-Sequence-Number: 13973 I am trying to restore tables and associated large objects under 7.4.2. I created a backup using pg_dump -U admin -Ft -b aesop > db.tar When I try to restore it using the following command: pg_restore -c -d aesop -U admin < db.tar I get the following message: pg_restore: [archiver (db)] could not execute query: ERROR: trigger "RI_ConstraintTrigger_17414" for table "vm_message" does not exist This is not a trigger I know about or created. What is the problem, this worked okay on 7.2.1 before I upgraded to 7.4.2. Even tried the --disable-triggers option on pg_restore, but this had no affect. Chris