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
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
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
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:
-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
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
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,
@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
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
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.
10 matches
Mail list logo