Skip site navigation (1) Skip section navigation (2)

Re: Problems With pg_dumpall and OIDs

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tim Gustafson <tjg(at)soe(dot)ucsc(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Problems With pg_dumpall and OIDs
Date: 2008-11-20 00:21:18
Message-ID: 24061.1227140478@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Tim Gustafson <tjg(at)soe(dot)ucsc(dot)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

In response to

pgsql-admin by date

Next:From: Greg SmithDate: 2008-11-20 05:04:31
Subject: Re: Very Urgent : Sequences Problem
Previous:From: Scott MarloweDate: 2008-11-19 23:17:17
Subject: Re: Problems With pg_dumpall and OIDs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group