Postgres Pro
Downloads
Home   >   mailing lists

Problems With pg_dumpall and OIDs - Mailing list pgsql-admin

From Tim Gustafson
Subject Problems With pg_dumpall and OIDs
Date
Msg-id 623884546.38971227134154902.JavaMail.root@mail-01.cse.ucsc.edu
Whole thread Raw
Responses Re: Problems With pg_dumpall and OIDs  ("Milen A. Radev" <milen@radev.net>)
Re: Problems With pg_dumpall and OIDs  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
Hello,

I currently have a old GForge installation running on Postgres 7.4.19.  GForge relies on the OID columns of their
applicationtables 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
thenew server, they are not getting OID columns, and then the data load portion of the SQL script appears to
essentiallybe 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
theOID information? 

Thanks for all your help!

Tim Gustafson
SOE Webmaster
UC Santa Cruz
tjg@soe.ucsc.edu
831-459-5354

pgsql-admin by date:

Previous
From: Barbara Stephenson
Date:
Subject: Re: open source ERD for postgresql database
Next
From: "Milen A. Radev"
Date:
Subject: Re: Problems With pg_dumpall and OIDs