Re: Restoring 7.4 "pg_dumpall -o" output in 8.1 fails - Mailing list pgsql-bugs

From gson@gson.org (Andreas Gustafsson)
Subject Re: Restoring 7.4 "pg_dumpall -o" output in 8.1 fails
Date
Msg-id 17623.380.987438.67314@guava.gson.org
Whole thread Raw
In response to Re: Restoring 7.4 "pg_dumpall -o" output in 8.1 fails  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tom Lane wrote:
> Try making the dump from the 7.4 server using 8.1's pg_dump(all).
>
> If you've already wiped the 7.4 installation then you'll have to deal
> with the incompatibilities yourself.  It looked like setting
> default_with_oids to true in the 8.1 server would help (although do you
> *really* need to preserve OIDs in your dump?  That -o switch is pretty
> well deprecated these days).  The "cannot delete from a view" is
> probably coming from an attempt to "DELETE FROM pg_shadow", which you
> can ignore.  You didn't show us any other problems.

What I did was to reinstall 7.4, which successfully restored the dump.

I don't think I actually need to preserve OIDs; I was using the -o
option out of habit, having been recommended to use it at some point.
In any case, that's not the point; I'm not looking for support or
workarounds, but simply to have the bug fixed. Whether or not I need
to preserve OIDs, the documented upgrade procedure for the case where
OIDs do need to preserved is not working, and that clearly is a bug in
either PostgreSQL itself or the documentation.
--
Andreas Gustafsson, gson@gson.org

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: BUG #2564: configuring secondry database as primary in replication.
Next
From: "PFudd"
Date:
Subject: BUG #2565: pg tool doesn't detect window size changes