Problem with pg_dump

[tyrrill_ed@xxxxxxx]

Hi All,

 

I am a developer of a product that uses a postgresql database (currently version 8.2.3.1).  We dump the database using pg_dumpall.  We are finding data corruption in the dump files about twice a month with a few thousand installations.  I have been able to track down the data corruption to the original dump file created by pg_dumpall.  In every case I’ve seen of the corruption 1 or 2 characters are missing.  The problem exhibits itself when loading the dump files.  Here is an example where two lines were combined:

 

ERROR:  extra data after last expected column

CONTEXT:  COPY ds_targets, line 42: "1180635517879      3001   C:/SQLBackup/1180635517879      3001    C:/System Volume Information/"

 

The file bad row was:

 

1180635517879   3001    C:/SQLBackup/1180635517879   3001    C:/System Volume Information/

 

It should have been two rows as follows:

 

1180635517879   3001    C:/SQLBackup/

1180635517879   3001    C:/System Volume Information/

 

Is this something that is perhaps fixed in postgresql 8.3?  Any assistance in resolving this problem would be appreciated.

 

Thanks,

Ed