This repo contains the Dockerfile and supplementary files for building a Postgres image including some useful extensions
This image was originally derived from official postgres:14-alpine docker image with some modifications since.
docker-entrypoint.sh is directly from docker-library.
A pre-built image is available from GHCR here.
Add the following to the bottom of your postgresql.conf file, replacing my_database with the name of the database to make pg_cron available in, making sure to reboot postgres after doing so.
This can't be done within this base image itself, as that would stop it from working within docker-compose.
shared_preload_libraries = 'pg_cron'
cron.database_name = 'my_database'
You can then enable the pg_cron extension on that database by running the following within that database.
CREATE EXTENSION pg_cron;Run the following on the database you want pg_repack to be available in.
CREATE EXTENSION pg_repack;