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 are compatible with PostgreSQL 15.x. The btree_gist and pgcrypto extensions must also be available. If using your cloud provider's DBaaS offering is not an option, then installing PostgreSQL manually on e.g. Windows Server is also possible. The remainder of this page provides some additional suggestions for customers installing PostgreSQL manually on Windows Server.

Installing PostgreSQL on Windows Server

We recommend using EDB's PostgreSQL installer for Windows, which you can find on their official downloads page. As mentioned previously, make sure you download the installer for PostgreSQL 15.x. After completing the setup wizard a PostgreSQL server should now be running on the machine. For an optimal deployment experience we suggest editing the following configuration options (which typically reside in C:\Program Files\PostgreSQL\15\postgresql.conf):

Configuration option	Suggested value	Reason
random_page_cost	1.1 if you're using a solid-state drive	The default value of 4 is only appropriate for machines with a hard disk drive.
unix_socket_directories	C:\PostgreSQL Sockets or some other newly created directory	Unix sockets are the simplest solution for Elimity Insights server containers to connect with a system-installed PostgreSQL server. Make sure the PostgreSQL service account has write access to the configured directory.