[postgis-users] Postgre 8.3.5 & PostGIS SVN 2008-11-13 Updates

[Paragon Corporation]

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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Balkan
Uraz
Sent: Saturday, November 15, 2008 3:43 AM
To: postgis-users at postgis.refractions.net
Cc: volkany at mobiliz.com.tr
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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081115/ab8f2fe9/attachment.html>