On 1 May 2012 11:22, Thom Brown <thom@xxxxxxxxx> wrote: > On 1 May 2012 11:12, Matthew Churcher <Matthew.Churcher@xxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
