Problem with restore on upgrading to 7.1
| От | Joseph Shraibman |
|---|---|
| Тема | Problem with restore on upgrading to 7.1 |
| Дата | |
| Msg-id | 3AEDCF21.E6A8BF13@selectacast.net обсуждение исходный текст |
| Ответы |
Re: Problem with restore on upgrading to 7.1
|
| Список | 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 по дате отправления: