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

http://traviscline.com/blog/2010/04/28/moving-postgis-databases-between-machines/

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

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;

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