PaleoEarthLabs wiki

One bucket of limited wisdom

User Tools

Site Tools


software:postgresql11

Differences

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

Link to this comparison view

software:postgresql11 [2019/06/17 06:42] (current)
christian created
Line 1: Line 1:
 +====== PostgreSQL & PostGIS ======
  
 +Installing/​upgrading to [[https://​www.postgresql.org]] version 11.3 and [[http://​postgis.net|PostGIS]] version 2.5.2 on Mac OS X/MacOS Sierra (v10.12).
 +
 +<note important>​This note is in draft stage and currently just a dump of snippets</​note>​
 +
 +The reason for a manual installation is that I want to utilise the GDAL framework utilised by QGIS and GMT. This setup naturally collides with Homebrew'​s setup to install GDAL as part of the dependency framework when installing postgis.
 +
 +
 +===== Preparation =====
 +
 +
 +So I am leaving the dependencies to homebrew apart from GDAL.
 +
 +
 +===== PostgreSQL =====
 +
 +<​code>​
 +./configure --with-perl --with-uuid=e2fs --with-python --with-libxml ​ --with-readline --with-bonjour --prefix=/​usr/​local/​pgsql/​11.3/​ --with-libraries=/​usr/​local/​Cellar/​readline/​7.0.5/:/​usr/​local/​Cellar/​ossp-uuid/​1.6.2_2/:/​Library/​Frameworks/​Python.framework/​
 +</​code>​
 +
 +
 +===== PostGIS =====
 +
 +<​code>​
 + ​./​configure --prefix=/​usr/​local/​pgsql/​11.3/​ --with-projdir=/​Library/​Frameworks/​PROJ.framework/​unix/​ --with-raster --with-topology --with-pgconfig=/​usr/​local/​pgsql/​11.3/​bin/​pg_config --with-geosconfig=/​Library/​Frameworks/​GEOS.framework/​unix/​bin/​geos-config ​
 +</​code>​
 +
 +{{tag>​GIS Database MacOS PostGIS PostgreSQL compilation software}}
software/postgresql11.txt · Last modified: 2019/06/17 06:42 by christian