Re: pg_upgrade: out of memory

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 believe this is data limit related as I see the error when
dumping database "template1" under user "postgres". Here's the output:-

[eg17ph01:ahastie] /ahastie $ pg_dump  -v -U postgres template1 > test.psql
Password:
pg_dump: reading schemas
pg_dump: reading user-defined tables
pg_dump: reading extensions
pg_dump: reading user-defined functions
pg_dump: reading user-defined types
pg_dump: reading procedural languages
pg_dump: reading user-defined aggregate functions
pg_dump: out of memory
[eg17ph01:ahastie] /ahastie $ xlc -qversion
IBM XL C/C++ for AIX, V12.1 (5765-J02, 5725-C72)
Version: 12.01.0000.0001

I've tried the requested SQL query which returns zero rows. Is this as
expected ?
I will try the same with release 9.1.6 to see if we can pinpoint this as
a potential AIX only issue or a 9.2.n issue. Also to confirm what
Matthew has observed.

Regards,
Andrew



On 28/09/12 16:12, Tom Lane wrote:
> "Carrington, Matthew (Produban)" <Matthew.Carrington@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  0x000000010002e354 in exit_horribly ()
>> #1  0x000000010003243c in pg_malloc ()
>> #2  0x0000000100008f14 in getAggregates ()
>> #3  0x000000010002fcac in getSchemaData ()
>> #4  0x0000000100001330 in main ()
> getAggregates() doesn't do that much.  Can we see the results of the
> query it would have been executing, namely
>
> SELECT tableoid, oid, proname AS aggname,
> pronamespace AS aggnamespace,
> pronargs, proargtypes,
> (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = proowner) AS rolname,
> proacl AS aggacl
> FROM pg_proc p
> WHERE proisagg AND (
> pronamespace !=
> (SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog')
>   OR EXISTS(SELECT 1 FROM pg_depend WHERE
> classid = 'pg_proc'::regclass AND
> objid = p.oid AND
> refclassid = 'pg_extension'::regclass AND
> deptype = 'e'));
>
>
>             regards, tom lane
>
>