search

CircleCI-Public / cimg-postgres

MIT License
8 stars 24 forks source link

How to configure Postgres settings #47

Closed PeterJCLaw closed 1 year ago

PeterJCLaw commented 2 years ago

Since switching to cimg/postgres:11.13 (from circleci/postgres:11-alpine-ram) we've seen intermittent errors like:

django.db.utils.OperationalError: out of shared memory
HINT:  You might need to increase max_locks_per_transaction.

While I'm not sure if the issue is actually related to the change of image, I can't see in the docs any means to configure the Postgres instance. As this setting is one which requires a postgres restart, ideally it's something I'd configure before the container starts.

Is this a case of creating a custom image, or is there a way to overlay Postgres' configuration via CI config?

FelicianoTech commented 1 year ago

reviewing

ChrisLusted commented 1 year ago

also looking how I can configure the Postgres instance. did you find a fix @PeterJCLaw @felicianotech?

PeterJCLaw commented 1 year ago

I don't think I did.

ChrisLusted commented 1 year ago

shame, thanks for the reply

JalexChen commented 1 year ago

Closed with #67