[postgis-users] How to change PostGIS (uninstall Old version andadd newer)

[Paragon Corporation]

Ravi,

Did you build the data set from scratch.  I think if you used the one we had
on the site, hmm that is probably the version after we were done deduping
and things.  The deduped set may very well lead to the same answers since it
would have gotten rid of any overlapping land.

As far as installing PostGIS 1.4.  You should be able to just run the
postgis_upgrade.sql file packaged in the contrib folder of PostGIS 1.4.  Did
you run into problems running that against your PostGIS 1.3 install?

Leo 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
ravivundavalli at yahoo.com
Sent: Monday, July 06, 2009 11:19 AM
To: postgis
Subject: [postgis-users] How to change PostGIS (uninstall Old version andadd
newer)


Hi
trying exercise PGCON2009.

found that query result for
SELECT SUM(ST_Area(the_geom))/1000 As totalwithoverlap_km,
ST_Area(ST_Union(the_geom))/1000 As no_overlap_km FROM land;

gives similar for both which is upsurd.

PostGIS version i have is 1.3.1 (PGSQL 8.3)

Trying ti install PostGIS 1.4

but the old PostGIS conflicts. How to safely uninstall it ??
and install PostGIS1.4 ??

Ravi Kumar




      Looking for local information? Find it on Yahoo! Local
http://in.local.yahoo.com/ _______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users