Skip to content

Instantly share code, notes, and snippets.

@nonZero

nonZero/create-postgis-db.sh

Created November 4, 2015 14:36
Show Gist options
  • Save nonZero/fb8519f1fd21d01a9bc7 to your computer and use it in GitHub Desktop.
Save nonZero/fb8519f1fd21d01a9bc7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
create-postgis-db.sh
sudo apt-get install postgis postgresql-9.3-postgis-2.1
sudo -iu postgres createuser proj123 -S -D -R
sudo -iu postgres createdb proj123 -O proj123
sudo -iu postgres psql -c \"alter user proj123 with password 'proj123';\"
sudo -iu postgres psql proj123 -c \"CREATE EXTENSION postgis;\
sudo -iu postgres psql proj123 -c \"CREATE EXTENSION postgis_topology;\""
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment