su
yum install gdal gdal-python geos proj proj-epsg proj-nad
easy_install -U geoalchemy geojson pylons shapely sphinx sqlalchemy
su
yum install postgresql postgresql-devel postgresql-server python-psycopg2 postgis
service postgresql initdb
service postgresql start
passwd postgres
su - postgres
psql -c "alter role postgres with password 'SET-PASSWORD-HERE';"
vim data/pg_hba.conf
# "local" is for Unix domain socket connections only
local all all md5
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
service postgresql restart
paster make-config georegistry production.ini
vim production.ini
su - postgres
createdb -E UTF8 template_postgis
createlang -d template_postgis plpgsql
PGSHARE=`pg_config --sharedir`
psql -d template_postgis -f `find $PGSHARE -name postgis.sql -o -name postgis-64.sql | tail -n 1`
psql -d template_postgis -f `find $PGSHARE -name spatial_ref_sys.sql | tail -n 1`
psql -d template_postgis -c 'GRANT ALL ON geometry_columns TO PUBLIC; GRANT ALL ON spatial_ref_sys TO PUBLIC;'
createuser -U postgres SET-USERNAME-HERE
psql -U postgres -c "alter role SET-USERNAME-HERE with password 'SET-PASSWORD-HERE';"
createdb -U postgres -T template_postgis -O SET-USERNAME-HERE SET-DATABASE-HERE
paster setup-app production.ini
bash deployment/refreshDocs.sh
wget http://www.gadm.org/data/shp/GTM_adm.zip -P gadm
unzip gadm/*.zip -d gadm
python utilities/loadGADM.py -c production.ini gadm
paster serve --daemon production.ini
dropdb -U postgres SET-DATABASE-HERE
createdb -U postgres -T template_postgis -O SET-USERNAME-HERE SET-DATABASE-HERE
paster setup-app production.ini