pg_dumpall segmentation fault - Mailing list pgsql-bugs

From A.Bhuvaneswaran
Subject pg_dumpall segmentation fault
Date
Msg-id Pine.LNX.4.44.0305081058550.2178-100000@Bhuvan.bksys.co.in
Whole thread Raw
List pgsql-bugs
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>

pgsql-bugs by date:

Previous
From: Sean Chittenden
Date:
Subject: Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance problem.
Next
From: Achilleus Mantzios
Date:
Subject: Re: [SQL] An unresolved performance problem.