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: postg...@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
