1.2- Software lliure

Think free as in free speech, not free beer

R.Stallman

Roadmap

Roadmap PostGIS

Github

Clone, pull request: manteniment

Llicències

http://www.gnu.org/licenses/license-list.es.html

• Geoserver: GNU / GPL v2
• PostgreSQL: PostgreSQL License (BSD/MIT)
• PostGIS: GNU / GPL v2

1.3.1 Arquitectures

http://geoserver.org/release/stable/

ESRI vs Open

http://mappinggis.com/2012/07/arcgis-for-server-vs-open-source/

Desktop software

http://desktop.arcgis.com/es/arcmap/10.3/get-started/system-requirements/database-requirements-postgresql.htm

1.3.2 Tecnologies

Sistemes operatius

http://geoserver.org/release/stable/

http://postgis.net/install/

Containers Java

• Java 9 is not currently supported
• The Oracle JRE is preferred, but OpenJDK has been known to work adequately
• Tomcat vs Jetty

GDAL

http://docs.geoserver.org/stable/en/user/data/raster/gdal.html

Des de PostGIS 2.0, inclòs (Per PostGIS Raster)
https://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html

OGR

https://trac.osgeo.org/gdal/wiki/DownloadingGdalBinaries

http://www.gdal.org/ogr_formats.html

Core i extensions 

http://geoserver.org/release/stable/

http://postgis.net/install/

http://docs.geoserver.org/latest/en/user/extensions/index.html#extensions

Documentació

http://docs.geoserver.org/

http://postgis.net/documentation/​

Alta disponibilitat

http://boundlessgeo.com/2013/04/geoserver-in-a-clustered-configuration-part-2/​

http://thebuild.com/presentations/pgha-fosdem-2016.pdf

2.1 Instalació i configuració

ssh root@139.162.247.52

2.1.1 Instalació Ubuntu

# Instalar darrera versió
apt-get install postgresql postgis

# Instalar versió específica
apt-get install postgresql-9.3-postgis-2.1
# Instalar pgRouting
sudo apt-get install postgresql-9.5-pgrouting

2.1.2 pg_hba.conf

# TYPE  DATABASE        USER            ADDRESS                 METHOD
local   all             postgres                                ident
local   all             all                                     md5
host    all             all             127.0.0.1/32            md5
#host   prova           prova           0.0.0.0/0               md5

2.1.3 postgresql.conf

listen_addresses = 'localhost'

2.1.4 Crear BDD

# Accedir a la consola
sudo -u postgres psql

#crear usuari
CREATE USER usuario LOGIN PASSWORD '------' NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;

#crear BDD
sudo -u postgres createdb -O usuario geodatos

#habilitar extensions
sudo -u postgres psql -d geodatos -c "CREATE EXTENSION postgis;"

2.1.5 Tipus espacials

http://workshops.boundlessgeo.com/postgis-spatialdbtips/introduction.html

Crear taula: http://postgis.net/install/

http://postgis.net/docs/manual-1.4/ch04.html#id417971

2.1.6 Workshop

http://workshops.boundlessgeo.com/postgis-intro/

2.3 Tuning for spatial

http://workshops.boundlessgeo.com/postgis-intro/tuning.html

2.3.3 Backup i restore

> /usr/bin/pg_dump --inserts -h localhost -U user -W gdb_nom > arxiu.dump

> sudo -u postgres psql
\c novabdd
\i arxiu.dump

https://dzone.com/refcardz/essential-postgis#chapter-4