postgresql-pglogical: vanilla extension is not working
It appears that installing vanilla-built code>postgresql-pglogical package is not working for some reason.
This Dockerfile:
FROM alpine:3.6
ARG pg_data=/var/lib/postgresql/data
RUN apk add --update su-exec
RUN apk add postgresql-pglogical --update --repository http://dl-3.alpinelinux.org/alpine/edge/testing/
RUN install -d -o postgres /run/postgresql && \
install -d -o postgres $pg_data && \
chmod 700 $pg_data
RUN su-exec postgres initdb --pgdata $pg_data
CMD su-exec postgres postgres -h "*" -D /var/lib/postgresql/data
Build it:
docker build --file Dockerfile --tag problem .
Run the server:
docker run problem
Attempt to create an extension:
docker exec -it b4c16862bb39 psql -U postgres -c 'create extension pglogical;'
ERROR: could not load library "/usr/lib/postgresql/pglogical.so": Error relocating /usr/lib/postgresql/pglogical.so: CatalogTupleInsert: symbol not found
The file code>/usr/lib/postgresql/pglogical.so is in place, but something is still wrong.
How to get rid of this error?
(from redmine: issue id 8119, created on 2017-11-08, closed on 2017-11-23)