This is a short description to get PostgreSQL v12 spatially enabled on [https://uberspace.de|Uberspace's]] U7. This is partly based on the guide Alexander Bilz has on his website but with some tweaks.
When following the Uberspace lab/manual for installing PostgreSQL, your installation is going to live in $HOME/opt/postgresql
, I will therefore use the $HOME/opt
directory for installing the additional dependencies for PostGIS.
Enable Postgresql version 12 (or others - in this guide I will use PGSQL v12) in your U7 - follow the manual and Uber Lab guide to get that going.
Some of the dependencies of PostGIS require cmake
such as SFCGAL (as do the Generic mapping tools which will also be used):
wget https://github.com/Kitware/CMake/releases/download/v3.21.0/cmake-3.21.0-linux-x86_64.sh sh cmake-3.21.0-linux-x86_64.sh && mv cmake-3.21.0-linux-x86_64 ~/bin/cmake
SFCGAL has a few dependencies:
The MPFR library, install instructions
./configure --prefix=/home/glorida/opt/mpfr
mkdir build && cd build ~/bin/cmake-3.21.0-linux-x86_64/bin/cmake -DCMAKE_INSTALL_PREFIX=/home/glorida/opt/CGAL -DMPFR_INCLUDE_DIR=/home/glorida/opt/mpfr/include/ -DMPFR_LIBRARIES=/home/glorida/opt/mpfr/lib/ -DCGAL_HEADER_ONLY=OFF -DCMAKE_BUILD_TYPE=Release .. make make install
~/bin/cmake-3.21.0-linux-x86_64/bin/cmake -DCMAKE_BUILD_TYPE=Release --install-prefix=/home/glorida/opt/geos .. '' make && make install <code> ===== PROJ Library ===== <code> wget https://download.osgeo.org/proj/proj-8.1.0.tar.gz
wget https://github.com/OSGeo/gdal/releases/download/v3.3.1/gdal-3.3.1.tar.gz
wget https://download.osgeo.org/postgis/source/postgis-3.1.3.tar.gz