Database.Dockerfile

FROM postgres:15.1

ARG POSTGRES_DB

# Install pg_cron extension
RUN apt-get update && apt-get install -y postgresql-15-cron

# Add pg_cron to shared_preload_libraries
RUN echo "shared_preload_libraries='pg_cron'" >> /usr/share/postgresql/postgresql.conf.sample
RUN echo "cron.database_name = '${POSTGRES_DB}'" >> /usr/share/postgresql/postgresql.conf.sample

# Create the pg_cron extension
RUN echo "CREATE EXTENSION pg_cron;" >> /docker-entrypoint-initdb.d/init-cron-schema.sql

# Run the init-cron-schema.sql script during container startup
CMD ["sh", "-c", "chmod +x /docker-entrypoint-initdb.d/init-cron-schema.sql && /usr/local/bin/docker-entrypoint.sh postgres"]