Re: Problem with restore on upgrading to 7.1 - Mailing list pgsql-general

From Joseph Shraibman
Subject Re: Problem with restore on upgrading to 7.1
Date
Msg-id 3AEDE479.FCA4B470@selectacast.net
Whole thread Raw
In response to Problem with restore on upgrading to 7.1  (Joseph Shraibman <jks@selectacast.net>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Copy
Next
From: Fran Fabrizio
Date:
Subject: DBI/AutoCommit/Postgres