This is an old revision of the document!
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;
CREATE EXTENSION postgis; command.
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.
Postgis Qgis Notes
http://planet.qgis.org/planet/user/2/tag/postgres%20%26%20postgis/
youtube vid about using QGIS to update
https://www.youtube.com/watch?v=oOhbbEkl4Kg
http://workshops.boundlessgeo.com/postgis-intro/
http://technobytz.com/automatic-sql-database-backup-postgres.html
General gis Notes
http://qgis.org/en/docs/index.html
http://www.spatialanalysisonline.com/
http://blog.geomusings.com/2013/12/11/building-a-simple-geodata-service-with-node-and-amazon-rds/