Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 86E1F633748 for ; Thu, 29 Oct 2009 15:50:22 -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 81595-07 for ; Thu, 29 Oct 2009 18:50:14 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.fmed.uba.ar (mail.fmed.uba.ar [157.92.152.1]) by mail.postgresql.org (Postfix) with ESMTP id 1BC15633454 for ; Thu, 29 Oct 2009 15:50:14 -0300 (ADT) Received: from [157.92.152.105] (unknown [157.92.152.105]) by mail.fmed.uba.ar (Postfix) with ESMTP id B144A39C223; Thu, 29 Oct 2009 15:28:32 -0200 (ARST) Message-ID: <4AE9D923.2010802@fmed.uba.ar> Date: Thu, 29 Oct 2009 15:04:19 -0300 From: Gerardo Herzig User-Agent: Thunderbird 2.0.0.6 (X11/20070801) MIME-Version: 1.0 To: Bryce Nesbitt CC: sql pgsql Subject: Re: pg_restore "WARNING: errors ignored on restore" References: <4AE8910E.4080201@obviously.com> In-Reply-To: <4AE8910E.4080201@obviously.com> Content-Type: text/plain; charset=ISO-8859-1 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/140 X-Sequence-Number: 33339 Bryce Nesbitt wrote: > 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 > > try using pg_restore ...... 2>errors.txt That would create the errors.txt file, with everything that is writen to STDERR (ussualy errors and warnings)