Hi,
I use pgsql 7.3.2.
The pg_dumpall fails while dumping the user-defined functions. But, the
pg_dump does fine. I have checked the archives and found two things.
1. To enable statement log and analyze. I did it.
2. To apply patch provided by Mr.Tom in the below link:
http://archives.postgresql.org/pgsql-bugs/2003-05/msg00011.php
I did it, but the problem still exists.
FYI, i have attached the sql log and the actual error thrown by pg_dumpall
(with -v). If you require further information, i can provide.
TIA.
regards,
bhuvaneswaran
<log>
LOG: query: SELECT proretset, prosrc, probin, provolatile, proisstrict, prosecdef, (SELECT lanname FROM
pg_catalog.pg_languageWHERE oid = prolang) as lanname
FROM pg_catalog.pg_proc WHERE oid = '20570'::pg_catalog.oid
LOG: query: SELECT pg_catalog.format_type('2279'::pg_catalog.oid, NULL)
LOG: query: SELECT description FROM pg_catalog.pg_description WHERE objoid = '20570'::pg_catalog.oid and classoid =
'pg_catalog.pg_proc'::pg_catalog.regclassand objsubid = 0
LOG: query: SELECT proretset, prosrc, probin, provolatile, proisstrict, prosecdef, (SELECT lanname FROM
pg_catalog.pg_languageWHERE oid = prolang) as lanname
FROM pg_catalog.pg_proc WHERE oid = '20571'::pg_catalog.oid
LOG: pq_recvbuf: unexpected EOF on client connection
</log>
<pg_dump-v>
pg_dump: dumping out indexes
pg_dump: dumping out user-defined procedural languages
pg_dump: dumping out user-defined functions
Segmentation fault (core dumped)
</pg_dump-v>