Changeset 1018

Show
Ignore:
Timestamp:
09/18/08 15:57:32 (4 years ago)
Author:
wyatt
Message:

More fixes to make installation process easier for n00bs.

Location:
core/trunk
Files:
2 modified

Legend:

Unmodified
Added
Removed
  • core/trunk/INSTALL.txt

    r1017 r1018  
    152152  * Make sure IPv4 host auth is set to md5 
    153153 
    154 * Switch to postgres user 
    155   * `createdb bycycle` 
     154* Switch to postgres user ($USER refers to the OS username of the user you 
     155  will be running byCycle under) 
     156  * `createdb $USER` 
    156157 
    157   * `createuser bycycle` (n, n, n in response to prompts) 
     158  * `createuser $USER` (n, n, n in response to prompts) 
    158159 
    159   * `createlang plpgsql bycycle` 
     160  * `createlang plpgsql $USER` 
    160161 
    161   * `psql -d bycycle` then `ALTER ROLE bycycle password 'sekret';` 
     162  * `psql -d $USER` then `ALTER ROLE $USER password 'sekret';` 
    162163 
    163164  * Insert lwpostgis.sql and spatial_ref_sys.sql into bycycle DB. These files 
    164165    are in /usr/share/postgresql-8.3-postgis on Ubuntu. 
    165     * `psql -d bycycle < lwpostgis.sql` 
    166     * `psql -d bycycle < spatial_ref_sys.sql` 
     166    * `psql -d $USER < lwpostgis.sql` 
     167    * `psql -d $USER < spatial_ref_sys.sql` 
    167168 
    168   * Change owner of public schema and all tables to bycycle 
    169     * `psql -d bycycle` 
    170     * `ALTER SCHEMA public OWNER TO bycycle;` 
    171     * `ALTER TABLE geometry_columns OWNER TO bycycle;` 
    172     * `ALTER TABLE spatial_ref_sys OWNER TO bycycle;` 
     169  * Change owner of public schema and all tables to $USER 
     170    * `psql -d $USER` 
     171    * `ALTER DATABASE $USER OWNER TO $USER;` 
     172    * `ALTER SCHEMA public OWNER TO $USER;` 
     173    * `ALTER TABLE geometry_columns OWNER TO $USER;` 
     174    * `ALTER TABLE spatial_ref_sys OWNER TO $USER;` 
    173175 
    174176* Exit from postgres user 
     
    177179  is an example for Portland, OR. 
    178180  * `cd repo/core/trunk/byCycle/scripts` 
    179   * `./integrate.py -r portlandor -d portlandor/pirate -l str06oct` 
     181  * `./integrate.py -r portlandor -d pirate -l str06oct` 
    180182 
    181183Deployment 
  • core/trunk/byCycle/scripts/integrate.py

    r888 r1018  
    1 #!/usr/bin/env python2.5 
     1#!/usr/bin/env python 
    22############################################################################### 
    33# $Id: shp2pgsql.py 187 2006-08-16 01:26:11Z bycycle $