Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 79188650222 for ; Wed, 19 Nov 2008 20:21:23 -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 22733-10 for ; Wed, 19 Nov 2008 20:21:20 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 1CA75650220 for ; Wed, 19 Nov 2008 20:21:19 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id mAK0LIVa024062; Wed, 19 Nov 2008 19:21:18 -0500 (EST) To: Tim Gustafson cc: pgsql-admin@postgresql.org Subject: Re: Problems With pg_dumpall and OIDs In-reply-to: <623884546.38971227134154902.JavaMail.root@mail-01.cse.ucsc.edu> References: <623884546.38971227134154902.JavaMail.root@mail-01.cse.ucsc.edu> Comments: In-reply-to Tim Gustafson message dated "Wed, 19 Nov 2008 14:35:54 -0800" Date: Wed, 19 Nov 2008 19:21:18 -0500 Message-ID: <24061.1227140478@sss.pgh.pa.us> From: Tom Lane 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/122 X-Sequence-Number: 30776 Tim Gustafson writes: > 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, 7.4's pg_dump doesn't know it ought to do that. Try taking the dump with the newer version's pg_dump(all). regards, tom lane