Hi Postgis-Users,

I would like to ask about upgrade Postgis from 1.3.5 to 1.5.5.

Currently we are using *PostgreSQL 8.3x and Postgis 1.3.5*. We need to
upgrade Postgis to 1.5.5 for some internal reasons.
We have added some EPSG in table spatial_ref_sys (EPSG: 3022, 21781, 23030,
26986, 900913)
List of functions that we are using:
ST_X,ST_Y,ST_xmin,ST_ymin,ST_xmax,ST_ymax,ST_centroid,ST_BUFFER,ST_SetSRID,ST_Transform,ST_collect,ST_Distance_Sphere,ST_GeomFromText,ST_Distance,ST_DWithin,ST_Equals,ST_Within,ST_Expand,ST_Extent

I have referenced from "Postgis install" and "Postgis release note" *(there
are no functions change and EPSG change)*. As I figure out in my case, I
just only install new Postgis 1.5.5 and run "soft upgrade" script to
complete the upgrade stuff.

I don't know if any potential risks base on our environment, functions can
be occur during upgrading Postgis.
Anybody have experience about this one, Could you give some advise to help
me minimum the risks.


Reference:
http://postgis.refractions.net/documentation/manual-1.5/ch02.html#hard_upgrade
http://postgis.refractions.net/documentation/manual-1.5/release_notes.html

Thanks in advance.

Salduos.

-- 
*Liem Nguyen (DBA)

AXON ACTIVE VIETNAM*
*www.axonactive.vn***

10th Floor, Hai Au Building, 39B Truong Son, Ward 4, Tan Binh District, Ho
Chi Minh City, Vietnam
T +84 8 629 738 59, F +84 8 381 134 89, M +84 168 994 8897
*8897 +10° 48' 32.72", +106° 39' 51.58"*
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to