Skip to content

Instantly share code, notes, and snippets.

@marshall007

marshall007/Dockerfile

Created February 21, 2019 18:06
Show Gist options
  • Save marshall007/f76eb1d0e01b331c22e7b4a4c05ae2ab to your computer and use it in GitHub Desktop.
Save marshall007/f76eb1d0e01b331c22e7b4a4c05ae2ab to your computer and use it in GitHub Desktop.
Download ZIP
Postgres 11 Alpine (postgraphile v4.4.0 live queries)
Raw
Dockerfile
FROM postgres:11-alpine
ENV WAL2JSON_COMMIT_ID=7360b1e8ddfaa5e0c033a084241885587056c674
# Compile the wal2json plugin from sources and install it
RUN apk --update add --virtual build-dependencies build-base git openssh \
&& git clone https://github.com/eulerto/wal2json -b master --single-branch \
&& cd /wal2json \
&& git checkout $WAL2JSON_COMMIT_ID \
&& USE_PGXS=1 make && USE_PGXS=1 make install \
&& cd / \
&& rm -rf wal2json \
&& apk del build-dependencies
COPY postgresql.conf /usr/local/share/postgresql/postgresql.conf.sample
Raw
postgresql.conf
listen_addresses = '*'
wal_level = logical # minimal, replica, or logical
max_wal_senders = 10 # max number of walsender processes
max_replication_slots = 10 # max number of replication slots
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment