From: | Dick Kniep <dick(dot)kniep(at)lindix(dot)nl> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Date range problem on pg_restore |
Date: | 2009-02-23 09:23:27 |
Message-ID: | vmime.49a26b0f.5e7a.65a2ad471b1e1051@mail.pl20 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Serge Fonville | 2009-02-23 09:27:52 | Re: PostgreSQL clustering with DRBD |
Previous Message | Tim Uckun | 2009-02-23 08:46:59 | Re: PostgreSQL clustering with DRBD |