Problem with restore on upgrading to 7.1 - Mailing list pgsql-general

From Joseph Shraibman
Subject Problem with restore on upgrading to 7.1
Date
Msg-id 3AEDCF21.E6A8BF13@selectacast.net
Whole thread Raw
Responses Re: Problem with restore on upgrading to 7.1
List pgsql-general
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

pgsql-general by date:

Previous
From: "mike"
Date:
Subject: Re: Problem installing Postgresql
Next
From: Tom Lane
Date:
Subject: Re: Problem with restore on upgrading to 7.1