# Next-Gen PostgreSQL Convenience Image Beta

**URL:** <https://discuss.circleci.com/t/next-gen-postgresql-convenience-image-beta/40278>\
**Category:** CircleCI Images\
**Tags:** postgresql, next-gen, cimg, docker, convenience-images\
**Created:** [June 3, 2021, 6:10pm UTC](https://discuss.circleci.com/t/next-gen-postgresql-convenience-image-beta/40278 "2021-06-03T18:10:25Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![FelicianoTech](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/felicianotech/32/21348_2.png) [@FelicianoTech](https://discuss.circleci.com/u/FelicianoTech)\
**Post date:** [June 3, 2021, 6:10pm UTC](https://discuss.circleci.com/t/next-gen-postgresql-convenience-image-beta/40278/1 "2021-06-03T18:10:25Z")

</div>

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:

- [Docker Hub](https://hub.docker.com/r/cimg/postgres)
- [GitHub repository](https://github.com/CircleCI-Public/cimg-postgres)

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

---

<div class="post-metadata">

**Author:** ![imajes](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/imajes/32/27260_2.png) [@imajes](https://discuss.circleci.com/u/imajes)\
**Post date:** [June 3, 2021, 9:19pm UTC](https://discuss.circleci.com/t/next-gen-postgresql-convenience-image-beta/40278/2 "2021-06-03T21:19:11Z")

</div>

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`

---

<div class="post-metadata">

**Author:** ![BeeeQueue](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/beeequeue/32/27570_2.png) [@BeeeQueue](https://discuss.circleci.com/u/BeeeQueue)\
**Post date:** [June 8, 2021, 11:44am UTC](https://discuss.circleci.com/t/next-gen-postgresql-convenience-image-beta/40278/3 "2021-06-08T11:44:39Z")

</div>

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

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

```auto
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

```

---

<div class="post-metadata">

**Author:** ![FelicianoTech](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/felicianotech/32/21348_2.png) [@FelicianoTech](https://discuss.circleci.com/u/FelicianoTech)\
**Post date:** [June 8, 2021, 2:51pm UTC](https://discuss.circleci.com/t/next-gen-postgresql-convenience-image-beta/40278/4 "2021-06-08T14:51:28Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![FelicianoTech](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/felicianotech/32/21348_2.png) [@FelicianoTech](https://discuss.circleci.com/u/FelicianoTech)\
**Post date:** [October 21, 2021, 1:05am UTC](https://discuss.circleci.com/t/next-gen-postgresql-convenience-image-beta/40278/5 "2021-10-21T01:05:09Z")

</div>

This image has been promoted to GA/stable. [Next-Gen PostgreSQL Convenience Image Now GA/Stable](https://discuss.circleci.com/t/next-gen-postgresql-convenience-image-now-ga-stable/41595)

---

<div class="post-metadata">

**Author:** ![FelicianoTech](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/felicianotech/32/21348_2.png) [@FelicianoTech](https://discuss.circleci.com/u/FelicianoTech)\
**Post date:** [October 21, 2021, 1:05am UTC](https://discuss.circleci.com/t/next-gen-postgresql-convenience-image-beta/40278/6 "2021-10-21T01:05:18Z")

</div>


