Re: [GENERAL] pg_upgrade: out of memory

2012-10-01 Thread Carrington, Matthew (Produban)
: [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

Re: [GENERAL] pg_upgrade: out of memory

2012-10-01 Thread Andrew Hastie
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

Re: [GENERAL] pg_upgrade: out of memory

2012-10-01 Thread Tom Lane
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

Re: [GENERAL] pg_upgrade: out of memory

2012-10-01 Thread Carrington, Matthew (Produban)
. 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

Re: [GENERAL] pg_upgrade: out of memory

2012-10-01 Thread Carrington, Matthew (Produban)
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

Re: [GENERAL] pg_upgrade: out of memory

2012-10-01 Thread Andrew Hastie
.. 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

Re: [GENERAL] pg_upgrade: out of memory

2012-10-01 Thread Tom Lane
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

Re: [GENERAL] pg_upgrade: out of memory

2012-09-28 Thread Carrington, Matthew (Produban)
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

Re: [GENERAL] pg_upgrade: out of memory

2012-09-28 Thread Tom Lane
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

Re: [GENERAL] pg_upgrade: out of memory

2012-09-28 Thread Carrington, Matthew (Produban)
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

Re: [GENERAL] pg_upgrade: out of memory

2012-09-28 Thread Tom Lane
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

Re: [GENERAL] pg_upgrade: out of memory

2012-09-21 Thread Carrington, Matthew (Produban)
] 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

Re: [GENERAL] pg_upgrade: out of memory

2012-09-21 Thread Tom Lane
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

[GENERAL] pg_upgrade: out of memory

2012-09-20 Thread Carrington, Matthew (Produban)
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

Re: [GENERAL] pg_upgrade: out of memory

2012-09-20 Thread Tom Lane
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

Re: [GENERAL] pg_upgrade: out of memory

2012-02-14 Thread Bruce Momjian
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

[GENERAL] pg_upgrade: out of memory

2012-02-06 Thread deepak
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