Getting up and running with PostGIS in a jiffy

I’ve posted this before on my old blog so this is a repeat for those looking to get going with PostGIS in a hurry. This procedure should work on Ubuntu Jaunty or Ubuntu Karmic and possibly earlier versions.

sudo apt-get install postgresql-8.3-postgis
sudo su - postgres
createuser -s -d -r -l -P -E timlinux
createdb gis
createlang plpgsql gis
psql gis < /usr/share/postgresql-8.3-postgis/lwpostgis.sql
psql gis < /usr/share/postgresql-8.3-postgis/spatial_ref_sys.sql

Having done that, you should be able to connect to the database by creating a new postgis connection in QGIS. After that you can start to load data into your spatial database using SPIT (QGIS plugin to import shapefiles into QGIS) or the shp2psql command line tool.

November 28th, 2009 in Postgres & PostGIS

2 Comments

jatorreDecember 1st, 2009 at 12:50 am

I have posted a description on how to install postgresql 8.4 with postgis 1.4 at http://biodivertido.blogspot.com/2009/10/install-postgresql-84-and-postgis-140.html

But be careful this installs Geos 3.0 and the really really fast options, like unions, from 1.4, comes with geos 3.1

adminDecember 5th, 2009 at 10:36 am

Cool stuff. I am looking forward to using PostgreSQL 8.4 and Postgis 1.4! Thanks for the link Javi!

Regards

Tim

Leave a comment

You must be logged in to post a comment.