Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
general:cutover_notes [2014/09/08 21:45] – [Postgis Qgis Notes] rfilegeneral:cutover_notes [2014/11/26 21:26] (current) – [Linux] rfile
Line 2: Line 2:
  
  
-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/43187/are-there-any-tricks-to-using-a-schema-other-than-public-in-postgis 
  
-http://gis.stackexchange.com/questions/2182/moving-a-postgis-installation/2323#2323 
  
-http://blog.cleverelephant.ca/2010/09/postgis-back-up-restore.html 
  
- +==== Backups Notes ====
-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;  +
- +
- +
-<box 95% orange> +
-http://postgis.net/docs/manual-2.1/postgis_installation.html#create_new_db_extensions +
- +
-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. +
- +
- +
- +
-</box> +
-==== 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 http://technobytz.com/automatic-sql-database-backup-postgres.html
  
- +http://www.backupcentral.com/mr-backup-blog-mainmenu-47/13-mr-backup-blog/404-amazon-glacier-release.html
-==== Generalgis Notes ====+
  
  
-http://qgis.org/en/docs/index.html+http://backuppc.sourceforge.net/
  
-http://www.spatialanalysisonline.com/