Search Postgresql Archives

Re: pg_upgrade: out of memory

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Carrington, Matthew (Produban)" <Matthew.Carrington@xxxxxxxxxxxxxx> 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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux