Changeset 1018
- Timestamp:
- 09/18/08 15:57:32 (3 years ago)
- Location:
- core/trunk
- Files:
-
- 2 modified
-
INSTALL.txt (modified) (2 diffs)
-
byCycle/scripts/integrate.py (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
core/trunk/INSTALL.txt
r1017 r1018 152 152 * Make sure IPv4 host auth is set to md5 153 153 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` 156 157 157 * `createuser bycycle` (n, n, n in response to prompts)158 * `createuser $USER` (n, n, n in response to prompts) 158 159 159 * `createlang plpgsql bycycle`160 * `createlang plpgsql $USER` 160 161 161 * `psql -d bycycle` then `ALTER ROLE bycyclepassword 'sekret';`162 * `psql -d $USER` then `ALTER ROLE $USER password 'sekret';` 162 163 163 164 * Insert lwpostgis.sql and spatial_ref_sys.sql into bycycle DB. These files 164 165 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` 167 168 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;` 173 175 174 176 * Exit from postgres user … … 177 179 is an example for Portland, OR. 178 180 * `cd repo/core/trunk/byCycle/scripts` 179 * `./integrate.py -r portlandor -d p ortlandor/pirate -l str06oct`181 * `./integrate.py -r portlandor -d pirate -l str06oct` 180 182 181 183 Deployment -
core/trunk/byCycle/scripts/integrate.py
r888 r1018 1 #!/usr/bin/env python 2.51 #!/usr/bin/env python 2 2 ############################################################################### 3 3 # $Id: shp2pgsql.py 187 2006-08-16 01:26:11Z bycycle $