Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 4558163380A for ; Wed, 28 Oct 2009 15:51:21 -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 01896-02 for ; Wed, 28 Oct 2009 18:51:17 +0000 (UTC) X-Greylist: delayed 00:06:39.830935 by SQLgrey-1.7.6 Received: from mail3.sea5.speakeasy.net (mail3.sea5.speakeasy.net [69.17.117.5]) by mail.postgresql.org (Postfix) with ESMTP id 3D5B16336E6 for ; Wed, 28 Oct 2009 15:51:13 -0300 (ADT) Received: (qmail 29052 invoked from network); 28 Oct 2009 18:44:31 -0000 Received: from digital-subscriber-line.bepress.com (HELO xena.bepress.com) ([216.27.183.41]) (envelope-sender ) by mail3.sea5.speakeasy.net (qmail-ldap-1.03) with SMTP for ; 28 Oct 2009 18:44:31 -0000 Received: from [192.168.1.146] (unknown [192.168.1.146]) by xena.bepress.com (Postfix) with ESMTP id 934C173572 for ; Wed, 28 Oct 2009 11:44:30 -0700 (PDT) Message-ID: <4AE8910E.4080201@obviously.com> Date: Wed, 28 Oct 2009 11:44:30 -0700 From: Bryce Nesbitt User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.22) Gecko/20090605 SeaMonkey/1.1.17 (Ubuntu-1.1.17+nobinonly-0ubuntu0.8.04.1) MIME-Version: 1.0 To: sql pgsql Subject: pg_restore "WARNING: errors ignored on restore" Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=-10 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200910/133 X-Sequence-Number: 33332 So when restoring a particular DB with pg_restore, I get "WARNING: errors ignore on restore". Is there a way to dump a list of those errors? # /usr/local/bin/pg_restore8.3 -d SUP-3067 -h 192.168.1.93 -p 5433 -U postgres -L toc_with_parts_commented_out.txt -v production_db.dump.20091016 .... pg_restore8.3: setting owner and privileges for FK CONSTRAINT api1_view_test_arguments_test_fkey pg_restore8.3: setting owner and privileges for FK CONSTRAINT api1_view_test_expected_results_test_fkey WARNING: errors ignored on restore: 985