PostgreSQL database
The Elimity Insights server manages all of its persistent data in a PostgreSQL database. For SaaS customers we perform the setup and maintenance of PostgreSQL servers behind the scenes. These installation instructions are mainly useful for on-prem deployments. We strongly recommend using your cloud provider's DBaaS offering to set up a PostgreSQL database. More specifically, Elimity Insights servers officially support PostgreSQL 17.x. The btree_gist, pgcrypto and plv8 extensions must also be available. If using your cloud provider's DBaaS offering is not an option, then installing PostgreSQL manually on e.g. a Linux VM is also possible.
We heavily recommend creating a dedicated database and user for Elimity Insights. More specifically, we suggest the following steps:
Create a dedicated PostgreSQL user with no privileges and a strong authentication mechanism
Create a dedicated database and assign the new user as its owner