From: | Søren Neigaard <s(dot)neigaard(at)mobilethink(dot)dk> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | 'Bad timestamp external representation' error when restoring database |
Date: | 2002-09-04 08:36:51 |
Message-ID: | 006101c253ee$381dbcb0$200110ac@mt45neigaard |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have made a 'pg_dump database_name > dump_file' from a 7.1 database, and
then I tried a 'psql database_name < dump_file' on a empty 7.1 database. But
this gives me the following error:
--------- error ----------
You are now connected as new user postgres.
ERROR: ProcedureCreate: procedure plpgsql_call_handler already exists with
same arguments
ERROR: Language plpgsql already exists
You are now connected as new user dba.
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
ERROR: copy: line 3580, Bad timestamp external representation '2002-08-23
08:31:60.00+02'
PQendcopy: resetting connection
--------- error ----------
Why do I get this error when I made the dump from a 7.1 to a 7.1, is that
not a bit strange? What can I do to work around this?
Med venlig hilsen/Best regards
Søren Neigaard
System Architect
................................
Mobilethink A/S
Arosgaarden
Åboulevarden 23, 5.sal
DK - 8000 Århus C
Telefon: +45 86207800
Direct: +45 86207810
Fax: +45 86207801
Email: s(dot)neigaard(at)mobilethink(dot)dk
Web: www.mobilethink.dk
................................
From | Date | Subject | |
---|---|---|---|
Next Message | frbn | 2002-09-04 09:23:56 | Re: help please |
Previous Message | Søren Neigaard | 2002-09-04 08:32:44 | FIXED: Please help - Keep getting authentication failure when trying to restore database |