[ADMIN] Problems With pg_dumpall and OIDs

2008-11-19 Thread Tim Gustafson
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

Re: [ADMIN] Problems With pg_dumpall and OIDs

2008-11-19 Thread Milen A. Radev
Tim Gustafson написа: 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

Re: [ADMIN] Problems With pg_dumpall and OIDs

2008-11-19 Thread Tim Gustafson
A workaround: temporarily turn to on the value off the default_with_oids parameter in your configuration file (the defaults is off). I tried that, but still got warning messages about no OID columns when I imported the data into 8.2. :( Unless maybe I'm doing something wrong. I'm getting

Re: [ADMIN] Problems With pg_dumpall and OIDs

2008-11-19 Thread Scott Marlowe
On Wed, Nov 19, 2008 at 4:05 PM, Tim Gustafson [EMAIL PROTECTED] wrote: A workaround: temporarily turn to on the value off the default_with_oids parameter in your configuration file (the defaults is off). I tried that, but still got warning messages about no OID columns when I imported the

Re: [ADMIN] Problems With pg_dumpall and OIDs

2008-11-19 Thread Tom Lane
Tim Gustafson [EMAIL PROTECTED] 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