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


Ignore:
Timestamp:
09/19/10 16:44:30 (11 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • GIS/InstallationGuidelines/Linux

    v21 v22  
    77
    88== PostGIS ==
    9  * [http://postgis.refractions.net PostGIS] adds Spatial storage to [wiki:InstallationGuidelinesPostgreSQL PostgreSQL]
    10 (alternatively these can be installed as part of [http://opengeo.org/community/suite/download/ OpenGeoSuite])
    11 {{{
    12 apt-get install postgresql-8.3-postgis
     9[http://postgis.refractions.net PostGIS] adds Spatial storage to [wiki:InstallationGuidelinesPostgreSQL PostgreSQL]
     10 * alternatively these can be installed as part of [http://opengeo.org/community/suite/download/ OpenGeoSuite]
     11NB PostGIS in Debian Lenny is rather old - recommend using the version in Squeeze
     12{{{
     13apt-get install postgresql-8.4-postgis
    1314su postgres
    1415createdb gis
    1516createlang plpgsql gis
    16 psql -d gis -f /usr/share/postgresql-8.3-postgis/lwpostgis.sql
    17 psql -d gis -f /usr/share/postgresql-8.3-postgis/spatial_ref_sys.sql
     17psql -d gis -f /usr/share/postgresql-8.4-postgis/lwpostgis.sql
     18psql -d gis -f /usr/share/postgresql-8.4-postgis/spatial_ref_sys.sql
    1819}}}
    1920 * Add Spherical Mercator projection (900913. See http://www.cadmaps.com/gisblog/?p=81 for 54004):
     
    2627passwd postgres
    2728
    28 vim /etc/postgresql/8.3/main/postgresql.conf
     29vim /etc/postgresql/8.4/main/postgresql.conf
    2930listen_addresses = '*'
    3031
    31 vim /etc/postgresql/8.3/main/pg_hba.conf
     32vim /etc/postgresql/8.4/main/pg_hba.conf
    3233host    all         all         my.ip.add.ress/24     md5
    3334
    34 /etc/init.d/postgresql-8.3 restart
     35/etc/init.d/postgresql-8.4 restart
    3536
    3637vim /etc/iptables.rules
     
    5758sysctl -w kernel.shmall=2097152
    5859
    59 vim /etc/postgresql/8.3/main/postgresql.conf
     60vim /etc/postgresql/8.4/main/postgresql.conf
    6061
    6162# This default is probably ok
     
    9293maintenance_work_mem = 16MB
    9394
    94 /etc/init.d/postgresql-8.3 restart
     95/etc/init.d/postgresql-8.4 restart
    9596}}}
    9697