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
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? |