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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "mike"
Дата:
Сообщение: Re: Problem installing Postgresql
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Problem with restore on upgrading to 7.1