How to install PostgreSQL + PostGIS

install-postgis.sh

# Install Postgresql
sudo apt-get install -y postgresql postgresql-contrib

# Create a database and a user to access it
# this will prompt you for a database password
sudo -u postgres createuser -P USER_NAME_HERE
sudo -u postgres createdb -O USER_NAME_HERE DATABASE_NAME_HERE

# Test connecting to Postgresql
psql -h localhost -U USER_NAME_HERE DATABASE_NAME_HERE

# Add PostGIS support to the database
sudo apt-get install -y postgis postgresql-9.3-postgis-2.1
sudo -u postgres psql -c "CREATE EXTENSION postgis; CREATE EXTENSION postgis_topology;" DATABASE_NAME_HERE