Changes between Version 21 and Version 22 of GIS/InstallationGuidelines/Linux

Timestamp:

09/19/10 16:44:30 (14 years ago)

Author:

Fran Boon

Comment:

--

GIS/InstallationGuidelines/Linux

@@ -7 +7 @@
 
 == PostGIS ==
- * [http://postgis.refractions.net PostGIS] adds Spatial storage to [wiki:InstallationGuidelinesPostgreSQL PostgreSQL]
-(alternatively these can be installed as part of [http://opengeo.org/community/suite/download/ OpenGeoSuite])
-{{{
-apt-get install postgresql-8.3-postgis
+[http://postgis.refractions.net PostGIS] adds Spatial storage to [wiki:InstallationGuidelinesPostgreSQL PostgreSQL]
+ * alternatively these can be installed as part of [http://opengeo.org/community/suite/download/ OpenGeoSuite]
+NB PostGIS in Debian Lenny is rather old - recommend using the version in Squeeze
+{{{
+apt-get install postgresql-8.4-postgis
 su postgres
 createdb gis
 createlang plpgsql gis
-psql -d gis -f /usr/share/postgresql-8.3-postgis/lwpostgis.sql
-psql -d gis -f /usr/share/postgresql-8.3-postgis/spatial_ref_sys.sql
+psql -d gis -f /usr/share/postgresql-8.4-postgis/lwpostgis.sql
+psql -d gis -f /usr/share/postgresql-8.4-postgis/spatial_ref_sys.sql
 }}}
  * Add Spherical Mercator projection (900913. See http://www.cadmaps.com/gisblog/?p=81 for 54004):
@@ -26 +27 @@
 passwd postgres
 
-vim /etc/postgresql/8.3/main/postgresql.conf
+vim /etc/postgresql/8.4/main/postgresql.conf
 listen_addresses = '*'
 
-vim /etc/postgresql/8.3/main/pg_hba.conf
+vim /etc/postgresql/8.4/main/pg_hba.conf
 host    all         all         my.ip.add.ress/24     md5
 
-/etc/init.d/postgresql-8.3 restart
+/etc/init.d/postgresql-8.4 restart
 
 vim /etc/iptables.rules
@@ -57 +58 @@
 sysctl -w kernel.shmall=2097152
 
-vim /etc/postgresql/8.3/main/postgresql.conf
+vim /etc/postgresql/8.4/main/postgresql.conf
 
 # This default is probably ok
@@ -92 +93 @@
 maintenance_work_mem = 16MB
 
-/etc/init.d/postgresql-8.3 restart
+/etc/init.d/postgresql-8.4 restart
 }}}