Balkan, I guess the error is being caused by the extra geometry validation we are doing, though I thought it was set to not validate copy . One way to fix the error now you are back in the old PostGIS, is bring up the problem table and do an ST_IsValid check on the geometries something like SELECT count(*) FROM badtable WHERE ST_IsValid(the_geom) = false The notice section should give listing of bad geoms. That below one you have is pretty bad basically means you have a line or polygon that does not have enough points to be a line or polygon. Then youcan delete them or fix them. As far as these tiny upgrades go a dump restore is in general not necessary - my general approach 1) Backup db as you have done (as a precautionary measure). 2) Do a yum upgrade (if you are using CentOS, Fedora or Red Hat, the new PostgreSQL YUM repository is pretty good and always has the latest and greatest PostgreSQL builds) (different depending on OS) -- sort of described here - - http://www.postgresonline.com/journal/index.php?/archives/60-YUM-2-Almost-Id iots-Guide-to-upgrade-from-PostgreSQL-8.3.1-to-8.3.3.html http://www.postgresonline.com/journal/index.php?/archives/45-An-Almost-Idiot s-Guide-to-PostgreSQL-YUM.html 3) Recompile and install latest PostGIS. 4) reindex tables if necessary.
_____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Balkan Uraz Sent: Saturday, November 15, 2008 3:43 AM To: [email protected] Cc: [EMAIL PROTECTED] Subject: [postgis-users] Postgre 8.3.5 & PostGIS SVN 2008-11-13 Updates Dear All; We have been informed that Postgre 8.3.5 Update is critical for especially GIST indexes. Therefore we decided to upgrade both Postgre & PostGIS. We have backed up our system: * Postgre 8.3.3 * PostGIS 2008-10-08 SVN * PROJ.4 SVN * GEOS 3.0.0 We have then, upgraded to 8.3.5 Update for Postgre and 2008-11-13 SVN for PostGIS. However, we were not successful to restore our data back in some tables. The error was: ERROR: geometry requires more points HINT: "...000100000003000000E71A66683C954F40018926" <-- parse error at position 74 within geometry CONTEXT: COPY dunyayerlesimalanlari, line 12024, column the_geom: "0106000020E61000000100000001030000000100000003000000E71A66683C954F400189265 0C4184B40BF45274BAD934F40..." STATEMENT: COPY dunyayerlesimalanlari (gid, name, featype, the_geom) FROM stdin; We couldn't find a way, therefore we reverted all our system back to 8.3.3 and PostGIS 2008-10-08 SVN . Do you have any ideas on the error? How could we resolve that error? Also, not specific for this error; is there any predefined procedures for updating the Postgre & PostGIS instances? Thanks for your help, Regards, Balkan Uraz.
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
