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@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