Date range problem on pg_restore

Hi list,

We have a peculiar problem with a restore.

We have a database with many different schema's that all act as separate databases.

The data is backed up from postgresql 8.1 with the following commands in cron:

28 12 * * * /usr/bin/pg_dump -a -F c --disable-triggers -f /srv/currentBackup/comsupportdata --schema=comsupport cvix

16 1 * * * /usr/bin/pg_dump -s -f /srv/currentBackup/comsupportschema --schema=comsupport cvix

As you can see the schema is backed up separately from the data.

When I am trying to restore the data into another 8.1 postgresql db I get the following errors:

postgres(at)dev01:/home/dick$ pg_restore --disable-triggers --schema=comsupport -d cvix_test comsupportdata
pg_restore: ERROR:  date out of range: "11750113-05-05"
CONTEXT:  COPY planning, line 71654, column mijlpaaldatum: "11750113-05-05"
pg_restore: [archiver (db)] error returned by PQendcopy: ERROR:  date out of range: "11750113-05-05"
CONTEXT:  COPY planning, line 71654, column mijlpaaldatum: "11750113-05-05"

and the restore stops.

I have tried to get offending rows in the source db, but if i do a select on the table planning with a mijlpaaldatum > '9999-01-01' I get 0 rows back. So it looks like a problem in the backup.

Do you have any idea what I can do to get my data back?

Cheers,

D.Kniep