PaleoEarthLabs wiki

One bucket of limited wisdom

User Tools

Site Tools


software:postgresql11

PostgreSQL & PostGIS

Installing/upgrading to https://www.postgresql.org version 11.3 and PostGIS version 2.5.2 on Mac OS X/MacOS Sierra (v10.12).

This note is in draft stage and currently just a dump of snippets

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

./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/

PostGIS

 ./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 
software/postgresql11.txt · Last modified: 2019/06/17 06:42 by christian