Posted by & filed under Postgres & PostGIS.

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.

pixelstats trackingpixel

2 Responses to “Getting up and running with PostGIS in a jiffy”

    • admin

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

      Regards

      Tim

Leave a Reply

You must be logged in to post a comment.