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@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Thom Brown
Sent: 01 May 2012 11:23
To: Matthew Churcher
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Having trouble with pg_dumpall -o
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general