Having trouble with pg_dumpall -o

From: "Matthew Churcher" <Matthew(dot)Churcher(at)realvnc(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Having trouble with pg_dumpall -o
Date: 2012-05-01 10:12:29
Message-ID: 002801cd2782$ea2e3160$be8a9420$@realvnc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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'm beginning to think it could just be a bug but I'm not familiar with this
tool and wanted to run it by the community before jumping to conclusions.

Any help is appreciated!

Thanks in advanced,
Matt

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2012-05-01 10:22:42 Re: Having trouble with pg_dumpall -o
Previous Message roy hills 2012-05-01 08:12:07 Re: Database upgrading: upgrade server first or client first?