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