Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Problem with restore on upgrading to 7.1
Date
Msg-id 29975.988666051@sss.pgh.pa.us
Whole thread Raw
In response to Problem with restore on upgrading to 7.1  (Joseph Shraibman <jks@selectacast.net>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Joseph Shraibman
Date:
Subject: Problem with restore on upgrading to 7.1
Next
From: Lamar Owen
Date:
Subject: Re: More src install probs...