Thanks Thom, that's really useful to know however I've been unable to get it working with pg_dump either. Are you able to offer any insight there? What command line options are you using? I get the same result with: pg_dump -o mydatabase pg_dump mydatabase Thanks again, Matt -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Thom Brown Sent: 01 May 2012 11:23 To: Matthew Churcher Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Having trouble with pg_dumpall -o 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. -- Thom -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
