Re: Having trouble with pg_dumpall -o
| От | Thom Brown |
|---|---|
| Тема | Re: Having trouble with pg_dumpall -o |
| Дата | |
| Msg-id | CAA-aLv4KgG6fK2K_He8KwsnTsKkO=akNixgMGPTG7m4Vz-xQNg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Having trouble with pg_dumpall -o ("Matthew Churcher" <Matthew.Churcher@realvnc.com>) |
| Ответы |
Re: Having trouble with pg_dumpall -o
Re: Having trouble with pg_dumpall -o |
| Список | pgsql-general |
On 1 May 2012 11:12, Matthew Churcher <Matthew.Churcher@realvnc.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
В списке pgsql-general по дате отправления: