Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id B10B465015C for ; Wed, 19 Nov 2008 19:07:37 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 04916-02 for ; Wed, 19 Nov 2008 19:07:35 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail-01.cse.ucsc.edu (mail-01.cse.ucsc.edu [128.114.48.32]) by mail.postgresql.org (Postfix) with ESMTP id 5D58E64FCF3 for ; Wed, 19 Nov 2008 19:05:41 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail-01.cse.ucsc.edu (Postfix) with ESMTP id A20DDF30156 for ; Wed, 19 Nov 2008 15:05:39 -0800 (PST) X-Virus-Scanned: amavisd-new at Received: from mail-01.cse.ucsc.edu ([127.0.0.1]) by localhost (mail-01.cse.ucsc.edu [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id ce05Zyo6TFGy for ; Wed, 19 Nov 2008 15:05:39 -0800 (PST) Received: from mail-01.cse.ucsc.edu (mail-01.cse.ucsc.edu [128.114.48.32]) by mail-01.cse.ucsc.edu (Postfix) with ESMTP id 69D56F300FE for ; Wed, 19 Nov 2008 15:05:39 -0800 (PST) Date: Wed, 19 Nov 2008 15:05:39 -0800 (PST) From: Tim Gustafson To: pgsql-admin@postgresql.org Message-ID: <1772386216.39071227135939283.JavaMail.root@mail-01.cse.ucsc.edu> In-Reply-To: Subject: Re: Problems With pg_dumpall and OIDs MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Originating-IP: [128.114.49.22] X-Mailer: Zimbra 5.0.9_GA_2533.RHEL5_64 (ZimbraWebClient - FF3.0 (Win)/5.0.9_GA_2533.RHEL5_64) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200811/120 X-Sequence-Number: 30774 > A workaround: temporarily turn to "on" the value off the > "default_with_oids" parameter in your configuration file > (the defaults is "off"). I tried that, but still got warning messages about no OID columns when I imported the data into 8.2. :( Unless maybe I'm doing something wrong. I'm getting ready to "try again" shortly. Tim Gustafson SOE Webmaster UC Santa Cruz tjg@soe.ucsc.edu 831-459-5354