postgres_cron

Dockerfile for building postgresql:15.1 with pg_cron extension

This image is derived from official postgres:15.1 docker image and heavily inspired by spitzenidee/postgresql_base.

Dockerfile installs CitusData pg_cron extension installed for postgres database.

To change the database for pg_cron to be installed, give a value to PG_CRON_DB environment variable. It defaults to pg_cron.

Dockerfile and docker-entrypoint.sh files reside in https://github.com/ramazanpolat/postgres_cron

Building image

$ git clone https://github.com/ramazanpolat/postgres_cron.git
$ cd postgres_cron
$ docker build -t postgres_cron:15 .

Running image

$ docker run -d ramazanpolat/postgres_cron:15

Testing pg_cron

$ docker exec --it [container-id] bash
$ su - postgres
$ psql
psql$ CREATE TABLE public.cron_test(a int);
psql$ INSERT INTO public.cron_test values (1), (2), (3) RETURNING *;
psql$ SELECT * FROM public.cron_test;
# Will return 1,2,3
psql$ select pg_sleep(60);
psql$ INSERT INTO cron.job (schedule, command, nodename, nodeport, database, username) VALUES ('* * * * *', $$DELETE FROM public.cron_test;$$, '', 5432, 'postgres', 'postgres') RETURNING jobid;
psql$ SELECT * FROM public.cron_test;
# Must return nothing since we deleted it with pg_cron
psql$ DELETE FROM cron.job;
psql$ DROP TABLE public.cron_test;