Tuesday, April 10, 2012

Installing PostGIS 1.4.0 on Postgresql 8.4 on Ubuntu 10.04


Install postgres 8.4
sudo apt-get install postgresql postgresql-client postgresql-contrib pgadmin3
Install postgis
sudo apt-get install libpostgis-java osm2pgsql postgresql-8.4-postgis
Create template
sudo su postgres
createdb postgistemplate
createlang plpgsql postgistemplate
psql -d postgistemplate -f /usr/share/postgresql/8.4/contrib/postgis.sql
psql -d postgistemplate -f /usr/share/postgresql/8.4/contrib/spatial_ref_sys.sql
Testing successful installation
psql -d postgistemplate -c "SELECT postgis_full_version();"

1 comment:

  1. Not so far I have found new cool tool to work with postgresql on ubuntu - Valentina Studio. Its free edition can do things more than many commercial tools!!
    I very recommend check it. http://www.valentina-db.com/en/valentina-studio-overview