How to find Maximum number of connections required by CKAN and its Extension for accessing PostgreSQL #6164
Unanswered
Gauravp-NEC
asked this question in
Q&A
Replies: 1 comment
-
@amercader , With reference to your comment #6153 (comment).
But when I disable the Datastore (by removing the plugin and commenting the datastore configs), these connections in psql's "pg_stat_activity" table and those processes that was appearing in the postgres container was not visible as shown below: What is your thought on this behavior? why these connections and processes were not shown after disabling the datastore?
To resolving this error we should increase the value of "max_connection" parameter. How we can choose the value of this parameter for our CKAN setup to avoid this 'Fatal error: too many clients' ?
|
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
CKAN version: 2.7.2 (Installed via Docker)
Description:
In our CKAN environment we have configure CKAN extensions DataStore and DataPusher.
We have created "ckan_default" and "datastore_default" databases in PostgreSQL.
We have configured Apache file with WSGIDaemonProcess ckan_default display-name=ckan_default processes=4 threads=15.
Considering the SQLachemy, Queue size=5 and max overflow=10, we assume the below maximum number of connections required by CKAN and its extensions (DataStore and DataPusher) for accessing PostgreSQL:
Is the above information in the table is correct? Is "datastore" is a process or a background job in CKAN?
How we can find Maximum number of connections required by CKAN and its Extension (DataStore and DataPusher) for accessing PostgreSQL?
Beta Was this translation helpful? Give feedback.
All reactions