Re: Problem with restore on upgrading to 7.1

Поиск
Список
Период
Сортировка
От Joseph Shraibman
Тема Re: Problem with restore on upgrading to 7.1
Дата
Msg-id 3AEDE479.FCA4B470@selectacast.net
обсуждение исходный текст
Ответ на Problem with restore on upgrading to 7.1  (Joseph Shraibman <jks@selectacast.net>)
Список pgsql-general
No, I have a redhat 6.x system and I built the postgres myself from the
7.0.3 source.

Tom Lane wrote:
>
> Joseph Shraibman <jks@selectacast.net> writes:
> > psql:dumpall-2001-4-27:8452: ERROR:  copy: line 8933, Bad timestamp
> > external representation '2001-01-17 19:37:60.00-05'
>
> Are you on Mandrake by any chance?  Looks like your 7.0 installation
> had that infamous roundoff problem.
>
> I recommend manually changing "37:60" to "38:00" in the dump file,
> then you should be able to load it.
>
>                         regards, tom lane

--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio.  http://www.targabot.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Copy
Следующее
От: Fran Fabrizio
Дата:
Сообщение: DBI/AutoCommit/Postgres