Re: Problems With pg_dumpall and OIDs

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
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-19 23:17:17
Message-ID: dcc563d10811191517y41e069b1q8f00fb456ee5f523@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Nov 19, 2008 at 4:05 PM, Tim Gustafson <tjg(at)soe(dot)ucsc(dot)edu> 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 data into 8.2. :( Unless maybe I'm doing something wrong. I'm getting ready to "try again" shortly.

Did you reload / restart postgrseql after making the change? When you
psql into the server, what does

show default_with_oids;

say?

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2008-11-20 00:21:18 Re: Problems With pg_dumpall and OIDs
Previous Message Tim Gustafson 2008-11-19 23:05:39 Re: Problems With pg_dumpall and OIDs