Tim's Blog

Setting up Postgis on Ubuntu

Setting up PostGIS on Ubuntu Another reason I love Ubuntu - getting postgis + postgresql is really easy…

sudo apt-get install postgis postgresql-8.3-postgis
sudo su - postgres
createuser -s -d -r -l -P -E -e timlinux
exit

Enter prompts following above commands as needed. Now you have postgres installed and a user created. Next create an empty spatial database:

createdb qgis
createlang plpgsql qgis
psql qgis < /usr/share/postgresql-8.3-postgis/lwpostgis.sql
psql qgis < /usr/share/postgresql-8.3-postgis/spatial_ref_sys.sql

Easy peasy.


To Tumblr, Love PixelUnion