Changes between Version 7 and Version 8 of UsersWikiPostgisOnUbuntu


Ignore:
Timestamp:
03/28/10 03:33:09 (15 years ago)
Author:
johntate
Comment:

Added the change for postgresql 8.4, the move and rename of lwpostgis.sql

Legend:

Unmodified
Added
Removed
Modified

  • UsersWikiPostgisOnUbuntu

    v7 v8  
    8888 2b. If you installed from source:
    8989
    90   '''NOTE:''' this looks old...
     90  Pre postgresql 8.4 versions:
    9191
    9292        $ psql -d mytestdb -f /usr/share/postgresql/8.0/contrib/postgis-1.1.1/lwpostgis.sql
    9393
    9494        $ psql -d mytestdb -f /usr/share/postgresql/8.0/contrib/postgis-1.1.1/spatial_ref_sys.sql
     95
     96  In postgresql 8.4 lwpostgis.sql was moved and renamed, but spatial_ref_sys.sql remains the same though, so:
     97
     98        $ psql -d mytestdb -f /usr/share/postgresql/8.4/contrib/postgis-1.5.1/postgis/postgis.sql
     99
     100        $ psql -d mytestdb -f /usr/share/postgresql/8.4/contrib/postgis-1.5.1/spatial_ref_sys.sql
    95101
    96102 3. '''Make sure that your DB user has GRANT ALL on the "geometry_columns" table and GRANT SELECT on "spatial_ref_sys".'''