GIS notes

should probably use extensions to make apostgis database on the new server flatboy

still need to figure out if sql statments have been run during postgis install on ubuntu


Using the CREATE EXTENSION statement This is as simple as running a query in the data base where you want to enable 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

AWS notes

Installed qgis server from repository

deb trusty main

deb-source trusty main

Did this as root (sudo su)

gpg –export –armor D71472C4 | sudo apt-key add -
gpg –keyserver –recv D71472C4

Got the keys used above from a file:

Look for trusty and use the SignWith number