<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Times New Roman; font-size: 10Impr; color: #000000'>Thanks a lot Olivier, now everything is fine !<br>I am right now beginning to test geoadminsuite, mapfish and mapserver and trying to determine wich solution is the best for my work... <br>Could you answer to some question in case of i need some advice ?<br><br>Thanks anyway<br><br>Sophie<br><br>----- Mail Original -----<br>De: "Courtin Olivier" <olivier.courtin@camptocamp.com><br>À: "PostGIS Users Discussion" <postgis-users@postgis.refractions.net><br>Envoyé: Lundi 4 Août 2008 10:06:32 GMT +01:00 Amsterdam / Berlin / Berne / Rome / Stockholm / Vienne<br>Objet: Re: [postgis-users] JSON<br><br><br>On Aug 4, 2008, at 8:38 AM, Sophie GRAS wrote:<br><br>> Hi everybody,<br>> thnaks for your answers !<br>> I have downloaded a svn client, but after that how can i upgrade my <br>> postgis (i am so new at linux !!) ?<br><br>In a perfect world you just have to follow steps 1 and 2.<br>Zero step is describted as an extra... ;)<br><br>0) Check to have:<br>- svn client: which svn<br>- gcc and libc: which gcc<br>- autoconf, make which make && which autoconf<br>- postgresql with pg_config binary which pg_config<br>- lib iconv sudo ldconfig -v | grep iconv<br>- flex and bison which flex && which bison<br>- /usr/local/lib in LD_LIBRAY_PATH sudo ldconfig -v | grep /usr/local/ <br>lib<br> (if not: su -c "echo '/usr/local/lib' >> /etc/ld.so.conf && <br>ldconfig" )<br><br>not required but usefull:<br>- geos with geos-config binary which geos-config<br>- lib proj4 sudo ldconfig -v | grep proj<br><br>0') If you need to install Proj4 from source:<br>wget http://download.osgeo.org/proj/proj-4.6.0.tar.gz<br>tar xvzf proj4-4.6.0.tar.gz<br>cd proj4-4.6.0<br>./configure && make<br>sudo make install<br>sudo ldconfig<br>cd ..<br><br>0'') If you need to install GEOS from source:<br>wget http://geos.refractions.net/downloads/geos-3.0.0.tar.bz2<br>tar xvjf geos-3.0.0.tar.bz2<br>cd geos-3.0.0<br>./configure && make<br>sudo make install<br>sudo ldconfig<br>cd ..<br><br><br>1) To retrieve source code and compile:<br>svn checkout http://svn.refractions.net/postgis/branches/1.3 postgis-1.3<br>cd postgis-1.3/<br>sh autogen.sh<br>./configure<br>make<br>sudo make install<br>sudo ldconfig<br><br><br>2) And now to create a new spatial database:<br>createdb -U postgres foo<br>createlang -U postgres plpgsql foo<br>psql -U postgres foo < lwpostgis.sql<br>psql -U postgres foo < spatial_ref_sys.sql<br><br>And to check that everything is A OK:<br>psql -U postgres -c "SELECT postgis_full_version()" foo<br><br><br>HTH,<br><br><br>--<br>Olivier<br><br>_______________________________________________<br>postgis-users mailing list<br>postgis-users@postgis.refractions.net<br>http://postgis.refractions.net/mailman/listinfo/postgis-users<br></div></body></html>