I just updated to 7.1 and tried to restore my database that was dumped
with 7.0.3
psql:dumpall-2001-4-27:8452: ERROR: copy: line 8933, Bad timestamp
external representation '2001-01-17 19:37:60.00-05'
psql:dumpall-2001-4-27:8452: PQendcopy: resetting connection
CREATE
CREATE
<snip>
[root@d1 /var/lib/pgsql] tail +8933 dumpall-2001-4-27 | head
372 2 76124 2001-01-17 20:38:47.54-05 2001-01-17
20:38:50-05 12 13
[root@d1 /var/lib/pgsql] grep "19:37:60" dumpall-2001-4-27
175 2 71904 2001-01-17 19:37:60.00-05 2001-01-17
19:38:01-05 12 13
It appears that all my data was restored except for the table which had
the error(which happened to be my biggest table) of which none was
restored.
--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio. http://www.targabot.com