Managing Maximum Database Connections

By default, the PostgreSQL database allows a maximum of 115 concurrent connections. 15 are reserved for administrative users and 100 for regular users. Regular users would be Flame Family products, Burn nodes, and services (Wiretap, Wiretap Gateway, Transcoder, etc.).

It is possible to modify this value following these steps:

1. Make sure no Flame Family product is currently using this database (either locally or remotely)

2. Login a flame_db user:

   sudo -u flame_db -i

3. Stop the database:

   cd /opt/Autodesk/bin
   ./igniter --stop

4. Modify the postgresql.conf file:

   cd /var/opt/Autodesk/pgsql/17/data/
   vi postgresql.conf

5. Modify the max_connections value to suite your needs

   max_connections = 100

6. Save the file and restart the database

   cd /opt/Autodesk/bin
   ./igniter --start