[bitnami/postgresql] pg_cron shared pg library not installed with postgresql bitnami image

[gaikwy22]

Name and Version

bitnami/postgresql:13.3.0

What architecture are you using?

amd64

What steps will reproduce the bug?

Installed postgresql helm chart and set postgresqlSharedPreloadLibraries: "pg_cron"

What is the expected behavior?

No response

What do you see instead?

No such file pg_cron

Additional information

No response

[javsalgar]

Hi,

We're trying to be conservative on the amount of extensions we install because of size and vulnerability surface. If there is a clear demand from the community to add the extension, we can consider adding it as part of the catalog.

[github-actions]

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.

[github-actions]

Due to the lack of activity in the last 5 days since it was marked as "stale", we proceed to close this Issue. Do not hesitate to reopen it later if necessary.

[siddjellali]

Please reopen
pg_cron is essential for enterprise-level purposes.

[siddjellali]

For your information, I managed to make it work like this (it only works with PostgreSQL 15).

FROM bitnami/postgresql:15-debian-12

USER 0
RUN apt-get update && \
    apt-get install -y postgresql-15-cron && \
    printf "cron.database_name = 'xxxxxx'\ncron.timezone = 'PRC'\n" >> /opt/bitnami/postgresql/conf/conf.d/cron.conf && \
    cp -a /usr/share/postgresql/15/extension/pg_cron* /opt/bitnami/postgresql/share/extension/ && \
    cp -a /usr/lib/postgresql/15/lib/pg_* /opt/bitnami/postgresql/lib/ && \
    echo "host    all   user   127.0.0.1/32   trust" >> /opt/bitnami/postgresql/conf/pg_hba.conf

COPY --chown=1001:1001 docker-entrypoint-initdb.d/*.sql /docker-entrypoint-initdb.d/
USER 1001

ENV POSTGRESQL_SHARED_PRELOAD_LIBRARIES 'pgaudit,pg_cron'