Re: Having trouble with pg_dumpall -o

On 1 May 2012 11:22, Thom Brown <thom@linux.com> wrote:
> 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.

Actually I am mistaken here.  I was looking at the same table in a
different database in the dump.  The -o option works fine in
pg_dumpall.

--
Thom