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. Sound

Re: [GENERAL] Having trouble with pg_dumpall -o

2012-05-01 Thread Tom Lane
"Matthew Churcher" 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 critical. "Premature optimiza

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 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 eac

Re: [GENERAL] Having trouble with pg_dumpall -o

2012-05-01 Thread Thom Brown
On 1 May 2012 12:37, Matthew Churcher 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, only to reference the table

Re: [GENERAL] Having trouble with pg_dumpall -o

2012-05-01 Thread Thom Brown
On 1 May 2012 11:22, Thom Brown wrote: > On 1 May 2012 11:12, Matthew Churcher 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 du

Re: [GENERAL] Having trouble with pg_dumpall -o

2012-05-01 Thread Matthew Churcher
ostgresql.org [mailto:pgsql-general-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 wrote: > Thanks Thom, that's really

Re: [GENERAL] Having trouble with pg_dumpall -o

2012-05-01 Thread Thom Brown
On 1 May 2012 11:55, Matthew Churcher 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: > pg_dump -o mydatabase >

Re: [GENERAL] Having trouble with pg_dumpall -o

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

Re: [GENERAL] Having trouble with pg_dumpall -o

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

[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