Differential D6406

provenance: Configure the postgresql max_connections
ClosedPublic
Actions

Authored by vsellier on Oct 4 2021, 5:59 PM.

Details

Reviewers

ardumont

Group Reviewers

System administrators

Maniphest Tasks

T3487: Installation of the new provenance server

Commits

rSPSITEefb36f766516: provenance: Configure the postgresql max_connections

Summary

Configure cthe urrent default value for all the server using

the profile::postgresql::server profile to avoid to change
their configuration when not needed

some code format

Related to T3487

Test Plan

met:

diff origin/production/met.internal.softwareheritage.org current/met.internal.softwareheritage.org
*******************************************
+ Postgresql::Server::Config_entry[max_connections] =>
   parameters =>
     "ensure": "present",
     "path": false,
     "value": 1000
*******************************************
+ Postgresql_conf[max_connections] =>
   parameters =>
     "ensure": "present",
     "notify": "Class[Postgresql::Server::Service]",
     "target": "/etc/postgresql/13/main/postgresql.conf",
     "value": 1000
*******************************************
*** End octocatalog-diff on met.internal.softwareheritage.org

bardo

diff origin/production/bardo.internal.admin.swh.network current/bardo.internal.admin.swh.network
*******************************************
+ Postgresql::Server::Config_entry[max_connections] =>
   parameters =>
     "ensure": "present",
     "path": false,
     "value": 100                   <-------------- default value, it will not trigger a restart
*******************************************
+ Postgresql_conf[max_connections] =>
   parameters =>
     "ensure": "present",
     "notify": "Class[Postgresql::Server::Service]",
     "target": "/etc/postgresql/12/main/postgresql.conf",
     "value": 100
*******************************************
*** End octocatalog-diff on bardo.internal.admin.swh.network