From: | Thom Brown <thom(at)linux(dot)com> |
---|---|
To: | Matthew Churcher <Matthew(dot)Churcher(at)realvnc(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Having trouble with pg_dumpall -o |
Date: | 2012-05-01 10:22:42 |
Message-ID: | CAA-aLv4KgG6fK2K_He8KwsnTsKkO=akNixgMGPTG7m4Vz-xQNg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Willy-Bas Loos | 2012-05-01 10:36:58 | Re: how robust are custom dumps? |
Previous Message | Matthew Churcher | 2012-05-01 10:12:29 | Having trouble with pg_dumpall -o |