PostgreSQL installation

Document version: 214. Automatically generated.


PostgreSQL, is a powerful, open source object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.

Automate platform depends on PosgreSQL 13 which is used as a storage for bot definition, NLU phrases, user data and analytical events.


  • At least 1 dedicated machine available for installation


1. Install the server

Please install PostgreSQL 13 it using official installation manual.


PostgreSQL can be containerized

You can run PostgreSQL inside Docker container

2. Increase maximum connections count

Please make sure following configuration keys are set in postgresql.conf

max_connections = 2000

More details can be found here

3. Create databases

After provisioning server please create following databases

chatbots-adminCREATE DATABASE "chatbots-admin";
chatbots-cron-orchestratorCREATE DATABASE "chatbots-cron-orchestrator";
chatbots-analyticsCREATE DATABASE "chatbots-analytics";
chatbots-dialog-managerCREATE DATABASE "chatbots-dialog-manager";
chatbots-ssoCREATE DATABASE "chatbots-sso";
chatbots-thread-coordinatorCREATE DATABASE "chatbots-thread-coordinator";
chatbots-web-chatCREATE DATABASE "chatbots-web-chat";
chimeoCREATE DATABASE "chimeo";