Book Image

OpenShift Cookbook

By : Shekhar Gulati
Book Image

OpenShift Cookbook

By: Shekhar Gulati

Overview of this book

Table of Contents (19 chapters)
OpenShift Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Running OpenShift on a Virtual Machine
Index

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 the PostgreSQL cartridge. Please refer to the Adding the PostgreSQL cartridge to your application recipe in this chapter to learn how to install PostgreSQL cartridge.

How to do it…

Perform the following steps to update the PostgreSQL max_connections...