[bitnami/postgresql] provide wal2json

betaboon commented 1 year ago

Name and Version

bitnami/postgresql

What is the problem this feature will solve?

Including wal2json in the bitnami-postgresql images will remove the need from users to maintain their own bitnami-based container images for usecases where it is required.

What is the feature you are proposing to solve the problem?

wal2json is a postgresql-output-plugin that is widely being used for real-time data-updates between postgresql and services.

please include it by default in the bitnami-container-images.

wal2json is included out-of-the-box on azure, aws rds and google cloud for several years.

What alternatives have you considered?

We're currently building a custom container-image that is based on the bitnami-image. but this is maintenance hassle.

this is the Dockerfile that we are currently using:

ARG POSTGRESQL_TAG=15.1.0-debian-11-r3
FROM docker.io/bitnami/postgresql:${POSTGRESQL_TAG} as builder

ARG WAL2JSON_TAG=wal2json_2_5

USER root
RUN apt-get update && apt-get install -y gcc git make && rm -rf /var/lib/apt/lists/*
RUN git clone https://github.com/eulerto/wal2json.git --branch ${WAL2JSON_TAG}
RUN cd wal2json && USE_PGXS=1 make && USE_PGXS=1 make install

FROM docker.io/bitnami/postgresql:${POSTGRESQL_TAG}
COPY --from=builder /opt/bitnami/postgresql/lib/wal2json.so /opt/bitnami/postgresql/lib/

javsalgar commented 1 year ago

Hi,

Thank you so much for the feature request. In this sense, we are conservative in the number of plugins we add to the image, as it has several implications:

The size of the container may potentially increase
The attack surface also increases, as the plugin may have CVEs

Therefore, we would like first to understand whether this is a feature/plugin that is widely used by the community. I will leave this ticket open to see if more users request it.

betaboon commented 1 year ago

thanks for the reply. just for reference here's an old issue also referring to wal2json usage together with the bitnami postgres-image

https://github.com/bitnami/bitnami-docker-postgresql/issues/310

github-actions[bot] commented 1 year ago

This Issue has been automatically marked as "stale" because it has not had recent activity (for 15 days). It will be closed if no further activity occurs. Thanks for the feedback.

betaboon commented 1 year ago

still very much interested in this.