From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tim Gustafson <tjg@soe.ucsc.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: Problems With pg_dumpall and OIDs
Date: Wed, 19 Nov 2008 19:21:18 -0500
Message-ID: <24061.1227140478@sss.pgh.pa.us> (raw)
In-Reply-To: <623884546.38971227134154902.JavaMail.root@mail-01.cse.ucsc.edu>
References: <623884546.38971227134154902.JavaMail.root@mail-01.cse.ucsc.edu>
Tim Gustafson <tjg@soe.ucsc.edu> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, tjg@soe.ucsc.edu
Subject: Re: Problems With pg_dumpall and OIDs
In-Reply-To: <24061.1227140478@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox