Configure Database Server
This page should only enlighten the relevant parts for Zammad and is not meant to be a complete guide. It is only relevant for you if you are running an existing PostgreSQL server and want to run Zammad's database there as well.
WARNING
If you use database connection pooling software like PgBouncer, make sure to use a pooling mode that is fully compatible with PostgreSQL. Typically this is called “session connection pooling”. Transaction-based connection pooling is not supported and may lead to errors during database migrations.
Below you can the locations of the relevant PostgreSQL configuration files to adjust. Keep in mind that versions may differ from your setup - adapt where needed.
/etc/postgresql/{your version}/main/postgresql.confAdjust Pool Size
Within database.yml (config/ directory) you can define the allowed pool size. By default each Zammad process takes up to 50 connections (pool: 50).
This should be fairly enough for every use case. If you experience database connection timeouts or similar pool errors, this usually indicates to other issues that are relevant to your PostgreSQL.
Adjust max_connections (mandatory)
Zammad will take up to 200 connections by default, with below command you can raise this limit fairly high.
Raise maximum allowed number of connections:
sed -i "/max_connections/c\max_connections = 2000" <postgresql-configuration-file>Apply changes by restarting postgresql and Zammad (in this order):
systemctl restart postgresql zammadAdjust PostgreSQL for bigger instances (optional)
WARNING
Check below settings first and ensure your system is able to provide the requirements! Below settings are what we found to be useful, everything else is out of scope of this documentation!
Some caching improvements:
sed -i "/shared_buffers/c\shared_buffers = 2GB" <postgresql-configuration-file>sed -i "/temp_buffers/c\temp_buffers = 256MB" <postgresql-configuration-file>sed -i "/work_mem/c\work_mem = 10MB" <postgresql-configuration-file>sed -i "/max_stack_depth/c\max_stack_depth = 5MB" <postgresql-configuration-file>Apply changes by restarting postgresql and Zammad (in this order):
systemctl restart postgresql zammad