Installing PostGIS:

For Ubuntu users:

sudo apt-add-repository ppa:ubuntugis/ubuntugis-unstable
sudo apt-get update
sudo apt-get install postgis

sudo -u postgres createuser --superuser $USER
 sudo -u postgres psql

\password username;
CREATE DATABASE username;
CREATE DATABASE workshop;
\c workshop;
CREATE EXTENSION postgis;
CREATE EXTENSION postgis_topology;
Insert Code