Re: pg_upgrade: out of memory

"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