Hi all,
I've been doing some more research on this:
pg_dump -s works as expected
pg_dump -a works as expected
pg_dump -v shows that pg_dump crashes when dumping user defined functions.
There's a lot (~30) plpsql functions how could it be a problem.
I'm also surprised that pg_dump -s dumps those function without crashing.
Regards
On Thu, 24 Apr 2003, Tom Lane wrote:
> Date: Thu, 24 Apr 2003 10:57:25 -0400
> From: Tom Lane <tgl@sss.pgh.pa.us>
> To: ohp@pyrenet.fr
> Cc: pgsql-hackers list <pgsql-hackers@postgresql.org>
> Subject: Re: [HACKERS] pg_dump dumping... core
>
> ohp@pyrenet.fr writes:
> > pg_dump is crashing on 1 database here.
>
> Judging from the backtrace, malloc's data structures have gotten
> corrupted, probably as a result of somebody scribbling on a few more
> bytes than their buffer would hold.
>
> Since we haven't seen other reports of similar problems, I'm leaning
> to the theory that it's a platform-specific problem. In particular
> I wonder whether you might have a buggy version of vsnprintf(). I have
> seen Solaris 7's vsnprintf() overrun its output buffer --- could
> Unixware's have the same bug?
>
> It'd be worth trying the workaround outlined in FAQ_Solaris (add
> snprintf.o to LIBOBJS and rebuild libpq.so), just to see if it makes
> any difference. If not, you're in for some tedious debugging to try
> to figure out exactly where the culprit is :-(
>
> regards, tom lane
>
--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)
