002-setup.sh

#!/bin/sh

# Remove last line "shared_preload_libraries='citus'"
sed -i '$ d' ${PGDATA}/postgresql.conf

cat <<EOT >> ${PGDATA}/postgresql.conf
shared_preload_libraries='pg_cron'
cron.database_name='${POSTGRES_DB:-postgres}'
EOT

# Required to load pg_cron
pg_ctl restart

003-main.sql

CREATE EXTENSION pg_cron;

Dockerfile

FROM postgres:15.3-bullseye

RUN apt-get update && apt install -y curl ca-certificates gnupg | curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | gpg --dearmor | tee /etc/apt/trusted.gpg.d/apt.postgresql.org.gpg >/dev/null

RUN apt-get -y install postgresql-15-cron

COPY 002-setup.sh 003-main.sql /docker-entrypoint-initdb.d