Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 0C18D64FCF3 for ; Wed, 19 Nov 2008 18:41:19 -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 97190-07 for ; Wed, 19 Nov 2008 18:41:15 -0400 (AST) X-Greylist: delayed 00:05:17.940569 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 B9BBA64FC5A for ; Wed, 19 Nov 2008 18:41:15 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail-01.cse.ucsc.edu (Postfix) with ESMTP id 3330BF3020C for ; Wed, 19 Nov 2008 14:35:55 -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 UUJvafSospCv for ; Wed, 19 Nov 2008 14:35:55 -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 07912F301E2 for ; Wed, 19 Nov 2008 14:35:55 -0800 (PST) Date: Wed, 19 Nov 2008 14:35:54 -0800 (PST) From: Tim Gustafson To: pgsql-admin@postgresql.org Message-ID: <623884546.38971227134154902.JavaMail.root@mail-01.cse.ucsc.edu> Subject: 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/118 X-Sequence-Number: 30772 Hello, I currently have a old GForge installation running on Postgres 7.4.19. GForge relies on the OID columns of their application tables for different things. I'm trying to upgrade Postgres to 8.2, and in order to do so, I'm doing: pg_dumpall --oids --clean > foo.sql However, the "CREATE TABLE" statements in foo.sql don't have "WITH OIDS" specified, so when the tables are created in the new server, they are not getting OID columns, and then the data load portion of the SQL script appears to essentially be ignoring the OID information. Is there an updated pg_dumpall that fixes this problem? Was this a known issue in the 7.4.19 pg_dumpall that was fixed? Any suggestions on how best to get the data out of the 7.4 server and in to the 8.2 server while maintaining all the OID information? Thanks for all your help! Tim Gustafson SOE Webmaster UC Santa Cruz tjg@soe.ucsc.edu 831-459-5354