O'Reilly logo

OpenShift Cookbook by Shekhar Gulati

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Updating the PostgreSQL max_connections setting

The OpenShift PostgreSQL cartridge is configured to allow 100 client connections at the most. If the number of clients connected to the PostgreSQL server goes over this threshold, PostgreSQL will start giving the FATAL too many connections error. In this recipe, you will learn how to update the PostgreSQL cartridge max_connections setting.

The number of maximum connections is dictated by the max_connections setting in the postgresql.conf configuration file. OpenShift does not allow users to modify the postgresql.conf configuration file. The recommended way to change the max_connections setting is by setting an environment variable.

Getting ready

To complete this recipe, you will need an application ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required