On 1 May 2012 11:12, Matthew Churcher <Matthew.Churcher@realvnc.com> wrote:
> Hi PostgreSQL users,
>
> I'm having difficulty migrating a postgres 8.4.11 database to postgres
> 9.1.2, neither of the included pg_dumpall tools appear to honour the -o or
> --oids options and fail to dump the table oids from the old database as we
> require.
>
> I've tried various combinations and orders of options including those
> below:-
> pg_dumpall -o -p 5432 -U postgres > dump_o.sql
> pg_dumpall --oids -p 5432 -U postgres > dump_o.sql
> pg_dumpall -p 5432 -U postgres -o > dump_o.sql
> pg_dumpall -p 5432 -U postgres --oids > dump_o.sql
I can confirm that pg_dumpall's -o option doesn't appear to work, but
pg_dump's -o does. This looks like a bug to me, especially since it
also doesn't produce the WITH OIDS option on the CREATE TABLE
statement for tables which do have OIDs.
--
Thom