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 Name | SQL |
|---|---|
| chatbots-admin | CREATE DATABASE "chatbots-admin"; |
| chatbots-cron-orchestrator | CREATE DATABASE "chatbots-cron-orchestrator"; |
| chatbots-analytics | CREATE DATABASE "chatbots-analytics"; |
| chatbots-dialog-manager | CREATE DATABASE "chatbots-dialog-manager"; |
| chatbots-sso | CREATE DATABASE "chatbots-sso"; |
| chatbots-thread-coordinator | CREATE DATABASE "chatbots-thread-coordinator"; |
| chatbots-web-chat | CREATE DATABASE "chatbots-web-chat"; |
| chimeo | CREATE DATABASE "chimeo"; |
Updated 10 days ago