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