CircleCI-Public / CircleCI-Public/cimg-postgres

Feature Request: pg_cron configurable OR provide an image without it

Open
#116 10 comments 16 reactions 0 assignees View on GitHub
enhancement
Dominant language
Dockerfile
Stars
10
Forks
27
PR merge metrics
No merged PRs in 30d

Description

For our official CircleCI Docker Convenience Image support policy, please see [CircleCI docs](https://circleci.com/docs/convenience-images-support-policy).

This policy outlines the release, update, and deprecation policy for CircleCI Docker Convenience Images.

---

**Describe the Feature Request**
Allow for a way to exclude the pg_cron shared library OR provide a new image without pg_cron.

See support ticket https://support.circleci.com/hc/en-us/requests/145723

**Is your feature request related to a particular problem?**
The current image comes with pg_cron configured out of the box. This means that the pg_cron scheduler is launched on boot which will hold on to a connection to any test database. This is not ideal, since it breaks any build pipeline depending on dropping a test database as part of any test setup code (this is very common in a Rails app, for example).

We are unable to upgrade our build pipeline to anything after PG14.8. I believe there was a fix to pg_cron for 14.9. We are currently trying to upgrade to PG15.5, with the same problem.

**How will this feature request benefit CircleCI jobs using this image?**
We and others will be able to upgrade to an image after PG14.8 if we have jobs relying to dropping a database before setting it up for tests etc.

**Describe the solution you would like to see**
I'd like an easy configuration setting in the config.yml file OR a new image without the pg_cron shared libraries installed.

**Describe alternatives you have considered**
Adding custom logic to the build pipeline that terminates the pg_cron scheduler. This does add a certain amount of tech debt in our build pipeline - but, more importantly, it doesn't actually work since the pg_cron scheduler restarts itself when the pid is terminated.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.