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 11:39:20 |
Message-ID: | CAA-aLv7FBZM7ektpXnfm7B+Y9pSmB+ues3oskDqEJ+L4HBhjmQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 1 May 2012 11:22, Thom Brown <thom(at)linux(dot)com> wrote:
> 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.
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
From | Date | Subject | |
---|---|---|---|
Next Message | Thom Brown | 2012-05-01 11:42:32 | Re: Having trouble with pg_dumpall -o |
Previous Message | Matthew Churcher | 2012-05-01 11:37:15 | Re: Having trouble with pg_dumpall -o |