PostgreSQL max connections
The max_connections setting determines the maximum number of
concurrent connections allowed to the PE-PostgreSQL server. It should be configured to accommodate all
infrastructure nodes running PuppetDB.
PE Database
puppet_enterprise::profile::database::max_connections
400
An integer representing the number of concurrent connections allowed. The
minimum is 200.
Set the max_connections parameter to a number
greater than the sum of read and write connections across all PuppetDB instances in your PE installation, including compilers and the
primary server. The connection count from each instance should equal
(command processing threads * 2) + number of JRuby
instances. Rule out any underlying performance issues prior to
adjusting max_connections.
