Skip to content

Instantly share code, notes, and snippets.

@bitrut
Forked from rolo/gist:1481128
Created July 18, 2012 11:59
Show Gist options
  • Save bitrut/3135780 to your computer and use it in GitHub Desktop.
Save bitrut/3135780 to your computer and use it in GitHub Desktop.
Install Postgres 9.1, PostGIS and create PostGIS template on a clean Ubuntu 12.04 LTS
#!/bin/bash
sudo apt-get -y install postgresql-9.1 postgresql-server-dev-9.1 postgresql-client-9.1 postgresql-9.1-postgis
sudo su postgres -c'createdb -E UTF8 -U postgres template_postgis'
sudo su postgres -c'createlang -d template_postgis plpgsql;'
sudo su postgres -c'psql -U postgres -d template_postgis -c"CREATE EXTENSION hstore;"'
sudo su postgres -c'psql -U postgres -d template_postgis -f /usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql'
sudo su postgres -c'psql -U postgres -d template_postgis -f /usr/share/postgresql/9.1/contrib/postgis-1.5/spatial_ref_sys.sql'
sudo su postgres -c'psql -U postgres -d template_postgis -c "select postgis_lib_version();"'
sudo su postgres -c'psql -U postgres -d template_postgis -c "GRANT ALL ON geometry_columns TO PUBLIC;"'
sudo su postgres -c'psql -U postgres -d template_postgis -c "GRANT ALL ON spatial_ref_sys TO PUBLIC;"'
sudo su postgres -c'psql -U postgres -d template_postgis -c "GRANT ALL ON geography_columns TO PUBLIC;"'
echo "Done!"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment