Re: Having trouble with pg_dumpall -o

Thanks Thom, that's really useful to know however I've been unable to get
it working with pg_dump either. Are you able to offer any insight there?
What command line options are you using?

I get the same result with:
pg_dump -o mydatabase
pg_dump mydatabase

Thanks again, Matt

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Thom Brown
Sent: 01 May 2012 11:23
To: Matthew Churcher
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Having trouble with pg_dumpall -o

On 1 May 2012 11:12, Matthew Churcher <Matthew(dot)Churcher(at)realvnc(dot)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

--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general