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
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... |