Changes between Version 6 and Version 7 of GeoDjangoDebianLennyInstall


Ignore:
Timestamp:
10/24/2008 11:43:06 AM (7 years ago)
Author:
adamfast
Comment:

template_postgis is the "right" (referred to in many other places) name for the base db. Changing to reflect that convention.

Legend:

Unmodified
Added
Removed
Modified
  • GeoDjangoDebianLennyInstall

    v6 v7  
    1111{{{
    1212$ sudo su - postgres
    13 $ createdb -E UTF8 postgis_template # Create the template spatial database.
    14 $ createlang -d postgis_template plpgsql # Adding PLPGSQL language support.
    15 $ psql -d postgis_template -f /usr/share/postgresql-8.3-postgis/lwpostgis.sql
    16 $ psql -d postgis_template -f /usr/share/postgresql-8.3-postgis/spatial_ref_sys.sql
    17 $ psql -d postgis_template # Enabling users to alter spatial tables.
    18 postgis_template=# GRANT ALL ON geometry_columns TO PUBLIC;
    19 postgis_template=# GRANT ALL ON spatial_ref_sys TO PUBLIC;
     13$ createdb -E UTF8 template_postgis # Create the template spatial database.
     14$ createlang -d template_postgis plpgsql # Adding PLPGSQL language support.
     15$ psql -d template_postgis -f /usr/share/postgresql-8.3-postgis/lwpostgis.sql
     16$ psql -d template_postgis -f /usr/share/postgresql-8.3-postgis/spatial_ref_sys.sql
     17$ psql -d template_postgis # Enabling users to alter spatial tables.
     18template_postgis=# GRANT ALL ON geometry_columns TO PUBLIC;
     19template_postgis=# GRANT ALL ON spatial_ref_sys TO PUBLIC;
    2020}}}
    2121
     
    5252
    5353= Creating a database =
    54 Now when creating a new database, use postgis_template as template (substitute in the appropriate database owner and the database name:
     54Now when creating a new database, use template_postgis as template (substitute in the appropriate database owner and the database name:
    5555{{{
    5656sudo su postgres
    57 createdb -T postgis_template -O db_user db_name
     57createdb -T template_postgis -O db_user db_name
    5858}}}
    5959
Back to Top