Problem with restore on upgrading to 7.1

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Problem with restore on upgrading to 7.1
Date: 2001-04-30 20:46:25
Message-ID: 3AEDCF21.E6A8BF13@selectacast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)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(at)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(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brian Z 2001-04-30 21:20:51 Primary Keys
Previous Message David Pieper 2001-04-30 20:45:22 More src install probs...