[postgis-users] JSON

[Courtin Olivier]

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