Re: [HACKERS] 6.1 pg_dump core dump - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] 6.1 pg_dump core dump
Date
Msg-id 4395.901636946@sss.pgh.pa.us
Whole thread Raw
In response to 6.1 pg_dump core dump  (bower@image.Kodak.COM (J Christopher Bower))
List pgsql-hackers
bower@image.Kodak.COM (J Christopher Bower) writes:
> I decided to debug the 6.1 pg_dump source and determined that the core dump
> occured dumping tblinfo cleanup.  Specifically when structures allocated for
> sequence tables are being cleaned up.

It looks like this bug has been fixed in a different way in the current
pg_dump sources (clearTableInfo now knows that sequences don't have the
standard attributes).  It also looks like pg_dump has changed enough
since 6.1 that any patches wouldn't be easily transferred back and
forth anyway.

You might be able to run the current pg_dump against your 6.1 database
by recompiling the current pg_dump.c/.h/common.c atop the 6.1 libpq.
That should cure the protocol incompatibility.  However, pg_dump is
friendly enough with the system table layouts that I fear it might not
work with an old database anyway.

Probably your best bet is just to go ahead and use your patched pg_dump
to extract data from your old database.

            regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Bogus "Non-functional update" notices
Next
From: Tom Lane
Date:
Subject: Coping with backend crash in libpq