This is an old revision of the document!
Table of Contents
Linux
dragon is postgresql 8.4.11 postgis 1.5.1
flatboy is postgresql 9.3.5 postgis 2.1.2
using public schema in db not necessarily a good thing:
http://gis.stackexchange.com/questions/2182/moving-a-postgis-installation/2323#2323
http://blog.cleverelephant.ca/2010/09/postgis-back-up-restore.html
http://traviscline.com/blog/2010/04/28/moving-postgis-databases-between-machines/
Install notes
http://postgis.net/documentation/
http://postgis.refractions.net/
should probably use extensions to make apostgis database on the new server flatboy
http://postgis.net/docs/manual-2.1/postgis_installation.html#create_new_db_extensions
still need to figure out if sql statments have been run during postgis install on ubuntu
install3
http://technobytz.com/install-postgis-postgresql-9-3-ubuntu.html
Using the CREATE EXTENSION statement This is as simple as running a query in the data base where you want to enable PostGIS:
1 CREATE EXTENSION postgis;
psql -d [yourdatabase] -c “CREATE EXTENSION postgis;”
Topology is packaged as a separate extension and installable with command:
psql -d [yourdatabase] -c “CREATE EXTENSION postgis_topology;”
If you plan to restore an old backup from prior versions in this new db, run:
psql -d [yourdatabase] -f legacy.sql
You can later run uninstall_legacy.sql to get rid of the deprecated functions after you are done with restoring and cleanup.