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.

Prerequisites

  • At least 1 dedicated machine available for installation

Steps

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

DB NameSQL
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";