[GENERAL] Having trouble with pg_dumpall -o

2012-05-01 Thread Matthew Churcher
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

Re: [GENERAL] Having trouble with pg_dumpall -o

2012-05-01 Thread Thom Brown
On 1 May 2012 11:12, Matthew Churcher matthew.churc...@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

Re: [GENERAL] Having trouble with pg_dumpall -o

2012-05-01 Thread Matthew Churcher
Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Thom Brown Sent: 01 May 2012 11:23 To: Matthew Churcher Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Having trouble with pg_dumpall -o On 1 May 2012 11:12, Matthew Churcher

Re: [GENERAL] Having trouble with pg_dumpall -o

2012-05-01 Thread Thom Brown
On 1 May 2012 11:55, Matthew Churcher matthew.churc...@realvnc.com wrote: 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:

Re: [GENERAL] Having trouble with pg_dumpall -o

2012-05-01 Thread Matthew Churcher
-ow...@postgresql.org] On Behalf Of Thom Brown Sent: 01 May 2012 11:58 To: Matthew Churcher Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Having trouble with pg_dumpall -o On 1 May 2012 11:55, Matthew Churcher matthew.churc...@realvnc.com wrote: Thanks Thom, that's really useful to know

Re: [GENERAL] Having trouble with pg_dumpall -o

2012-05-01 Thread Thom Brown
On 1 May 2012 11:22, Thom Brown t...@linux.com wrote: On 1 May 2012 11:12, Matthew Churcher matthew.churc...@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

Re: [GENERAL] Having trouble with pg_dumpall -o

2012-05-01 Thread Thom Brown
On 1 May 2012 12:37, Matthew Churcher matthew.churc...@realvnc.com wrote: OK, I think I've worked out what's going on. I've got my wires crossed between table column OIDS (deprecated) and the OID which uniquely identifies each table (?always enabled?). We're not using OID for each column,

Re: [GENERAL] Having trouble with pg_dumpall -o

2012-05-01 Thread Matthew Churcher
@postgresql.org Subject: Re: [GENERAL] Having trouble with pg_dumpall -o On 1 May 2012 12:37, Matthew Churcher matthew.churc...@realvnc.com wrote: OK, I think I've worked out what's going on. I've got my wires crossed between table column OIDS (deprecated) and the OID which uniquely identifies each table

Re: [GENERAL] Having trouble with pg_dumpall -o

2012-05-01 Thread Tom Lane
Matthew Churcher matthew.churc...@realvnc.com writes: The triggers are being used to track changes to the tables. The developers are concerned that using string references for the table names in this case would create too much overhead as this is a frequent operation and is performance

Re: [GENERAL] Having trouble with pg_dumpall -o

2012-05-01 Thread Adrian Klaver
On 05/01/2012 05:06 AM, Matthew Churcher wrote: The triggers are being used to track changes to the tables. The developers are concerned that using string references for the table names in this case would create too much overhead as this is a frequent operation and is performance critical.