[postgis-users] JSON

[Sophie GRAS]

Thanks a lot Olivier, now everything is fine ! 
I am right now beginning to test geoadminsuite, mapfish and mapserver and trying to determine wich solution is the best for my work... 
Could you answer to some question in case of i need some advice ? 

Thanks anyway 

Sophie 

----- Mail Original ----- 
De: "Courtin Olivier" <olivier.courtin at camptocamp.com> 
À: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net> 
Envoyé: Lundi 4 Août 2008 10:06:32 GMT +01:00 Amsterdam / Berlin / Berne / Rome / Stockholm / Vienne 
Objet: Re: [postgis-users] JSON 


On Aug 4, 2008, at 8:38 AM, Sophie GRAS wrote: 

> Hi everybody, 
> thnaks for your answers ! 
> I have downloaded a svn client, but after that how can i upgrade my 
> postgis (i am so new at linux !!) ? 

In a perfect world you just have to follow steps 1 and 2. 
Zero step is describted as an extra... ;) 

0) Check to have: 
- svn client: which svn 
- gcc and libc: which gcc 
- autoconf, make which make && which autoconf 
- postgresql with pg_config binary which pg_config 
- lib iconv sudo ldconfig -v | grep iconv 
- flex and bison which flex && which bison 
- /usr/local/lib in LD_LIBRAY_PATH sudo ldconfig -v | grep /usr/local/ 
lib 
(if not: su -c "echo '/usr/local/lib' >> /etc/ld.so.conf && 
ldconfig" ) 

not required but usefull: 
- geos with geos-config binary which geos-config 
- lib proj4 sudo ldconfig -v | grep proj 

0') If you need to install Proj4 from source: 
wget http://download.osgeo.org/proj/proj-4.6.0.tar.gz 
tar xvzf proj4-4.6.0.tar.gz 
cd proj4-4.6.0 
./configure && make 
sudo make install 
sudo ldconfig 
cd .. 

0'') If you need to install GEOS from source: 
wget http://geos.refractions.net/downloads/geos-3.0.0.tar.bz2 
tar xvjf geos-3.0.0.tar.bz2 
cd geos-3.0.0 
./configure && make 
sudo make install 
sudo ldconfig 
cd .. 


1) To retrieve source code and compile: 
svn checkout http://svn.refractions.net/postgis/branches/1.3 postgis-1.3 
cd postgis-1.3/ 
sh autogen.sh 
./configure 
make 
sudo make install 
sudo ldconfig 


2) And now to create a new spatial database: 
createdb -U postgres foo 
createlang -U postgres plpgsql foo 
psql -U postgres foo < lwpostgis.sql 
psql -U postgres foo < spatial_ref_sys.sql 

And to check that everything is A OK: 
psql -U postgres -c "SELECT postgis_full_version()" foo 


HTH, 


-- 
Olivier 

_______________________________________________ 
postgis-users mailing list 
postgis-users at postgis.refractions.net 
http://postgis.refractions.net/mailman/listinfo/postgis-users 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080804/ea2b7070/attachment.html>