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@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
