I have posted to the general news group but need a more definitive response.

I am running Postgresql 6.1 on SunOS 5.5.1.  We are presently looking into 
upgrading to Postgresql 6.3.2, but are having a problem with pg_dump core
dumping. It looks like the output is OK, but I would like to know for sure.

I read that pg_dump 6.2 should be able to dump a 6.1 database but can not
locate the 6.2 source to try it.

I have tried dumping my database with the pg_dumpall provided from the 6.3.2 
tar file,but this also core dumps.

I have tried dumping the 6.1 database with 6.3.2 pg_dump, but get a user
authentication error.

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. I made the following changes in the 
getTables function.

    for (i=0;i<ntups;i++) {
        tblinfo[i].oid = strdup(PQgetvalue(res,i,i_oid));
        tblinfo[i].relname = strdup(PQgetvalue(res,i,i_relname));
        tblinfo[i].relarch = strdup(PQgetvalue(res,i,i_relarch));
        tblinfo[i].relacl = strdup(PQgetvalue(res,i,i_relacl));
        tblinfo[i].sequence = (strcmp (PQgetvalue(res,i,i_relkind), "S") == 0);

        /* Local fix - needs to be initialized to zero for sequence tables.
        */
 
        tblinfo[i].numatts = 0;
        tblinfo[i].attlen = 0;
        tblinfo[i].attlen = NULL;
        tblinfo[i].inhAttrs = NULL;
        tblinfo[i].attnames = NULL;
        tblinfo[i].typnames = NULL;
 
    }


I would like to know if my changes are appropriate, and how can I get the 
correct patch if one is available.  Any input would be appreciated.  Thanks
in advance.

Chris Bower
Software Engineer
Eastman Kodak

Mon, 27 Jul 1998 11:31:36 -0400
bower@image.Kodak.COM (J Christopher Bower)
6.1 pg_dump core dump
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

Tue, 28 Jul 1998 10:42:26 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] 6.1 pg_dump core dump 