Having trouble with pg_dumpall -o

Поиск
Список
Период
Сортировка
От Matthew Churcher
Тема Having trouble with pg_dumpall -o
Дата
Msg-id 002801cd2782$ea2e3160$be8a9420$@realvnc.com
обсуждение исходный текст
Ответы Re: Having trouble with pg_dumpall -o  (Thom Brown <thom@linux.com>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: roy hills
Дата:
Сообщение: Re: Database upgrading: upgrade server first or client first?
Следующее
От: Thom Brown
Дата:
Сообщение: Re: Having trouble with pg_dumpall -o