Postgres extensions are installed into incorrect path
I’ve noticed that postgresql extensions are installed a folder where postgresql does not see them.
The following examples Dockerfile depicts the problem:
FROM postgres:9.6.4-alpine
RUN apk add --update --update-cache --repository http://dl-3.alpinelinux.org/alpine/edge/testing/ postgresql-pglogical postgis
It looks like postgresql-pglogical and postgis install their extensions into /usr/share/postgresql/extension, while postgresql expects all extensions to be present at /usr/local/share/postgresql/extension (not the share directory in path).
Here’s an output from running apk info postgis —contents | head -n 20:
postgis-2.3.2-r2 contains:
usr/bin/shp2pgsql
usr/bin/raster2pgsql
usr/bin/pgsql2shp
usr/lib/liblwgeom-2.3.so.0
usr/lib/liblwgeom-2.3.so.0.0.0
usr/lib/postgresql/postgis-2.3.so
usr/lib/postgresql/rtpostgis-2.3.so
usr/lib/postgresql/postgis_topology-2.3.so
usr/share/postgresql/contrib/postgis-2.3/rtpostgis_upgrade_for_extension.sql
usr/share/postgresql/contrib/postgis-2.3/postgis_for_extension.sql
usr/share/postgresql/contrib/postgis-2.3/spatial_ref_sys.sql
usr/share/postgresql/contrib/postgis-2.3/rtpostgis_legacy.sql
usr/share/postgresql/contrib/postgis-2.3/postgis_comments.sql
usr/share/postgresql/contrib/postgis-2.3/rtpostgis.sql
usr/share/postgresql/contrib/postgis-2.3/legacy_minimal.sql
usr/share/postgresql/contrib/postgis-2.3/rtpostgis_for_extension.sql
usr/share/postgresql/contrib/postgis-2.3/postgis_upgrade.sql
usr/share/postgresql/contrib/postgis-2.3/topology_comments.sql
usr/share/postgresql/contrib/postgis-2.3/uninstall_topology.sql
How APK packages are being built? Is it possible to make them build with /usr/local/share/…?
(from redmine: issue id 7772, created on 2017-08-28, closed on 2017-09-15)