http://www.paolocorti.net/2008/01/30/installing-postgis-on-ubuntu/
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();"
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!!
ReplyDeleteI very recommend check it. http://www.valentina-db.com/en/valentina-studio-overview