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.
Posted on Wednesday July 30th