postgis install

 sudo apt-get install postgresql


l;
 
 
  1003  sudo apt-get install libproj-dev libxml2-dev postgresql-server-dev-8.4
 1004  sudo apt-get install libproj-dev libxml2-dev postgresql-server-dev-8.4.4
 1005  sudo apt-get install libproj-dev libxml2-dev postgresql-server-dev-8.4
 1006  psql
 1007  wget http://download.osgeo.org/geos/geos-3.2.2.tar.bz2
 1008  ls -ltr
 1009  mkdir postgis
 1010  mv geos-3.2.2.tar.bz2  postgis/
 1011  cd postgis/
 1012  ls
 1013  tar xvfj geos-3.2.2.tar.bz2 
 1014  cd geos-3.2.2
 1015  ./s
 1016  ./configure  && make
 1017  top
 1018  aptitude install checkinstall
 1019  checkinstall
 1020  cd ..
 1021  ls
 1022  wget http://postgis.refractions.net/download/postgis-1.5.1.tar.gz
 1023  ls -tlr
 1024  tar xvfz postgis-1.5.1.tar.gz 
 1025  cd postgis-1.5.1
 1026  ./configure  && make
 1027  checkinstall
 1028  cd ..
 1029  sudo ldconfig
 1030  gem install postgis_adapter
 1031  gem install pg
 1032  gem install GeoRuby

su postgres
psql template1

create database template_postgis with template = template1;
UPDATE pg_database SET datistemplate = TRUE where datname = 'template_postgis';

\c template_postgis

CREATE LANGUAGE plpgsql;
 
\i /usr/share/postgresql/8.4/contrib/postgis-1.5/postgis.sql

\i  /usr/share/postgresql/8.4/contrib/postgis-1.5/spatial_ref_sys.sql

GRANT ALL ON geometry_columns TO PUBLIC;
GRANT ALL ON spatial_ref_sys TO PUBLIC;
VACUUM FREEZE;


# Now exit database

# CREATE db
create database mark with template = template_postgis;


---NOTES
# ruby
module GeoRuby
module SimpleFeatures
DEFAULT_SRID=4326
end