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
er 2012 14:39
To: Carrington, Matthew (Produban)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_upgrade: out of memory
"Carrington, Matthew (Produban)" writes:
pg_dump: reading user-defined aggregate functions
Breakpoint 1, exit_horribly (modulename=0x0, fmt=0x10006a590 "
--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
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
"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
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
) 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
"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
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
"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?
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
"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
.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
"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
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
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
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 ab
17 matches
Mail list logo
