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:

Install 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:

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.

youtube vid about using QGIS to update