Search Postgresql Archives

Date range problem on pg_restore

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux