Next-Gen PostgreSQL Convenience Image Beta

The next-gen PostgreSQL beta image is now available. The following initial tags are available:

  • cimg/postgres:9.6.22 (cimg/postgres:9.6)
  • cimg/postgres:10.17
  • cimg/postgres:11.12
  • cimg/postgres:12.7
  • cimg/postgres:13.3

We’re looking feedback. If you have any, please post it here. Here’s some of what we’re looking for:

  • are you coming from the legacy image (circleci/postgres)? If so, how does this work for you? Faster? Slower? Missing something?
  • do you need a PostgreSQL version the beta doesn’t have yet? Let us know.

As this is a beta, these images aren’t considered stable yet. They can change at any time through the beta as we begin to optimize and tweak the images.

Links:

Feedback, questions, etc, please post them here. This forum thread will be updated when there’s significant changes to the image.

seeing this crop up:

ActiveRecord::StatementInvalid: PG::UndefinedFile: ERROR: could not open extension control file "/usr/lib/postgresql/%%MAJOR_VERSION%%/share/extension/citext.control": No such file or directory

We’re seeing the same thing as @imajes, extensions seem to not be working.

In our case we can’t use the uuid extension.

2021-06-08 11:30:26.365 UTC [148] ERROR:  could not open extension control file "/usr/lib/postgresql/%%MAJOR_VERSION%%/share/extension/uuid-ossp.control": No such file or directory
2021-06-08 11:30:26.365 UTC [148] STATEMENT:  CREATE EXTENSION IF NOT EXISTS "uuid-ossp"
2021-06-08 11:30:26.455 UTC [148] ERROR:  function uuid_generate_v4() does not exist

Thanks for the feedback. We’ll be taking a look.