Page MenuHomeSoftware Heritage

provenance: Configure the postgresql max_connections
ClosedPublic

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

Details

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

Diff Detail

Repository
rSPSITE puppet-swh-site
Lint
Automatic diff as part of commit; lint not applicable.
Unit
Automatic diff as part of commit; unit tests not applicable.

Event Timeline

vsellier created this revision.
This revision is now accepted and ready to land.Oct 4 2021, 6:26 PM