Problem migrating dump to latest CVS snapshot.
От | Gunnar R|nning |
---|---|
Тема | Problem migrating dump to latest CVS snapshot. |
Дата | |
Msg-id | x6elvpbkdu.fsf@thor.candleweb.no обсуждение исходный текст |
Ответы |
Re: Problem migrating dump to latest CVS snapshot.
Re: Problem migrating dump to latest CVS snapshot. |
Список | pgsql-general |
We have pgsql-7.0.2 running on a production platform doing nightly dumps. I tried to import this dump using psql to a pgsql server running from a cvs update of 7.1 I did today. All the data was imported OK except for the data in one table where I got the following message on import : ERROR: copy: line 154391, Bad timestamp external representation '2000-10-24 15:14:60.00+02' PQendcopy: resetting connection The result was that this table turned up with no rows at all after the import when it should have contained more than 900000 rows. I get exactly the same error trying to import into a 7.0.2 database on my laptop as well, so I guess the problem might have been around for a while. The production platform creating the dump file is Solaris 7 on an Ultra Sparc, while the laptop I'm importing the file on is Redhat Linux 6.1 on an x86 processor. The actual table "access_log" got these columns : a_accesstime timestamp 8 a_locid int4 4 a_catid int4 4 a_searchterm varchar 256 a_host varchar 64 a_requesturl varchar 128 a_action varchar 16 a_uid int4 4 a_pt_id int4 4 Do anybody have suggestions to where I should look for the error or what other data I need to supply to help somebody look into it ? If you look at the seconds part of the time above you notice 60, which make me wonder how that could get in there in the first place. So to me there seems to bugs, it is possible to get invalid times into the database and dump/restore breaks if you manage this. regards, Gunnar
В списке pgsql-general по дате отправления: