Re: [GENERAL] pg_upgrade: out of memory

2012-10-01 Thread Tom Lane
Andrew Hastie 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 don't want to tou

Re: [GENERAL] pg_upgrade: out of memory

2012-10-01 Thread Andrew Hastie
postgres_9.2.1/bin/pg_dumpall" --port 65432 --username "postgres" --schema-only --binary-upgrade -f pg_upgrade_dump_all.sql .. both of which worked without any problems. Hope that helps. Matthew -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: 01 Octob

Re: [GENERAL] pg_upgrade: out of memory

2012-10-01 Thread Carrington, Matthew (Produban)
--username "postgres" --schema-only --binary-upgrade -f pg_upgrade_dump_all.sql .. 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 (P

Re: [GENERAL] pg_upgrade: out of memory

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

Re: [GENERAL] pg_upgrade: out of memory

2012-10-01 Thread Tom Lane
"Carrington, Matthew (Produban)" 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 exist.. > (gdb) bt > #0

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 don't

Re: [GENERAL] pg_upgrade: out of memory

2012-10-01 Thread Carrington, Matthew (Produban)
) y Hope that helps. Matthew -----Original Message----- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: 28 September 2012 16:27 To: Carrington, Matthew (Produban) Subject: Re: [GENERAL] pg_upgrade: out of memory "Carrington, Matthew (Produban)" writes: > ... presumably pg_extensi

Re: [GENERAL] pg_upgrade: out of memory

2012-09-28 Thread Tom Lane
"Carrington, Matthew (Produban)" 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 () > #1 0x00010003243

Re: [GENERAL] pg_upgrade: out of memory

2012-09-28 Thread Carrington, Matthew (Produban)
that helps. Matthew -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: 28 September 2012 15:16 To: Carrington, Matthew (Produban) Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] pg_upgrade: out of memory "Carrington, Matthew (Produban)" writes: > I've

Re: [GENERAL] pg_upgrade: out of memory

2012-09-28 Thread Tom Lane
"Carrington, Matthew (Produban)" 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 where the error is being thrown?

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" exp

Re: [GENERAL] pg_upgrade: out of memory

2012-09-21 Thread Tom Lane
"Carrington, Matthew (Produban)" 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 database that confuses some recent

Re: [GENERAL] pg_upgrade: out of memory

2012-09-21 Thread Carrington, Matthew (Produban)
.pgh.pa.us] 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)" writes: > I have attempted to upgrade my Postgres installation this morning from 9.0.1 > t

Re: [GENERAL] pg_upgrade: out of memory

2012-09-20 Thread Tom Lane
"Carrington, Matthew (Produban)" 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 pg_dump to take hugely more memo

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