: [GENERAL] pg_upgrade: out of memory
Carrington, Matthew (Produban) matthew.carring...@produban.co.uk writes:
... presumably pg_extension is a 9.2 thing and I only have 9.0.1 installed.
I thought you were doing this test with 9.2? Oh wait, this is 9.2
pg_dump against 9.0 server. In that case
Hi Tom/Matthew,
Just to chime in on this thread - I'm currently validating Postgres on
AIXv7.1 and confirm that I also see the same error. I can reproduce the
error with 9.2.1 and 9.2.0 but unlike Matthew I'm using a built from
source build using the IBM xcl compiler rather than gcc.
I
Carrington, Matthew (Produban) matthew.carring...@produban.co.uk writes:
pg_dump: reading user-defined aggregate functions
Breakpoint 1, exit_horribly (modulename=0x0, fmt=0x10006a590 out of
memory\n)
at dumputils.c:1314
1314dumputils.c: A file or directory in the path name does not
.
Hope that helps.
Matthew
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: 01 October 2012 14:39
To: Carrington, Matthew (Produban)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_upgrade: out of memory
Carrington, Matthew (Produban) matthew.carring
worked without any problems.
Hope that helps.
Matthew
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: 01 October 2012 14:39
To: Carrington, Matthew (Produban)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_upgrade: out of memory
Carrington, Matthew
.. both of which worked without any problems.
Hope that helps.
Matthew
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: 01 October 2012 14:39
To: Carrington, Matthew (Produban)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_upgrade: out of memory
Andrew Hastie and...@ahastie.net writes:
Tom: Is this something we should get added into the AIX Platform
specific notes?
No, it's something we need to fix. See hackers thread:
http://archives.postgresql.org/pgsql-hackers/2012-10/msg00029.php
That #define isn't a bad quick-workaround if you
I've tried to explore the issue a bit more using 9.2.1. Here's a trace of the
build and dump tests ...
tar zxf postgresql-9.2.1.tar.gz
cd postgresql-9.2.1
uname -a
AIX sx1190a 1 6 000A707AD400 powerpc AIX
export OBJECT_MODE=64
export CFLAGS=-maix64
export LDFLAGS=-maix64 -Wl,-bbigtoc
export
Carrington, Matthew (Produban) matthew.carring...@produban.co.uk writes:
I've tried to explore the issue a bit more using 9.2.1. Here's a trace of the
build and dump tests ...
As long as you're building your own copy, how about building with
--enable-debug and getting a stack trace showing
To: Carrington, Matthew (Produban)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_upgrade: out of memory
Carrington, Matthew (Produban) matthew.carring...@produban.co.uk writes:
I've tried to explore the issue a bit more using 9.2.1. Here's a trace of the
build and dump tests ...
As long
Carrington, Matthew (Produban) matthew.carring...@produban.co.uk writes:
Reading symbols from
/ukmetmon/data/dataCollection/postgres_9.2.1/bin/pg_dump...(no debugging
symbols found)...done.
... hm, not sure why that didn't work, but anyway:
(gdb) bt
#0 0x00010002e354 in exit_horribly
]
Sent: 20 September 2012 15:48
To: Carrington, Matthew (Produban)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_upgrade: out of memory
Carrington, Matthew (Produban) matthew.carring...@produban.co.uk writes:
I have attempted to upgrade my Postgres installation this morning from 9.0.1
Carrington, Matthew (Produban) matthew.carring...@produban.co.uk writes:
As its AIX I don't have top but using topas and comparing it to other
processes running a successful pg_dumpall doesn't get very large at all.
Hmm. Best guess at this point is that there's some specific DDL in your
Hi,
I have attempted to upgrade my Postgres installation this morning from 9.0.1 to
9.2.0 and it failed with an out of memory problem using pg_dumpall to dump the
first database.
So after backing out the change and restarting level 9.0.1, I've done some
basic investigation into the failure of
Carrington, Matthew (Produban) matthew.carring...@produban.co.uk writes:
I have attempted to upgrade my Postgres installation this morning from 9.0.1
to 9.2.0 and it failed with an out of memory problem using pg_dumpall to dump
the first database.
Hm. I'm not aware of any reason for 9.2
On Mon, Feb 06, 2012 at 05:14:55PM -0500, deepak wrote:
Hi!
While running pg_upgrade, on one instance, it ran out of memory during the
final stages of upgrade
(just before it starts to link old database files to new ones).
We are using Postgres 9.1.1, and I see that there were some
Hi!
While running pg_upgrade, on one instance, it ran out of memory during the
final stages of upgrade
(just before it starts to link old database files to new ones).
We are using Postgres 9.1.1, and I see that there were some fixes to
pg_upgrade in 9.1.2, though
it doesn't mention anything
17 matches
Mail list logo