Puppet Class: profile::maps::postgresql_common

Defined in:
modules/profile/manifests/maps/postgresql_common.pp

Overview

SPDX-License-Identifier: Apache-2.0

Class: profile::maps::postgresql_common

Manages the postgresql configuration commone to master and replicas.

Parameters:

  • $shared_buffers: postgresql shared buffer. Default: 7680MB

  • $maintenance_work_mem: postgresql maintenance work mem. Default: 4GB

    (should only be overriden for tests or VMs on lab).

  • $max_worker_processes: maximum worker processes - can be up to numcpus

Parameters:

  • shared_buffers (String) (defaults to: lookup('profile::maps::postgresql_common::shared_buffers', { 'default_value' => '7680MB' }))
  • effective_cache_size (String) (defaults to: lookup('profile::maps::postgresql_common::effective_cache_size', { 'default_value' => '22GB' }))
  • maintenance_work_mem (String) (defaults to: lookup('profile::maps::postgresql_common::maintenance_work_mem', { 'default_value' => '4GB' }))
  • max_worker_processes (Integer) (defaults to: lookup('profile::maps::postgresql_common::max_worker_processes', { 'default_value' => 8 })) 


11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
 
# File 'modules/profile/manifests/maps/postgresql_common.pp', line 11

class profile::maps::postgresql_common(
    String  $shared_buffers        = lookup('profile::maps::postgresql_common::shared_buffers', { 'default_value' => '7680MB' }),
    String  $effective_cache_size  = lookup('profile::maps::postgresql_common::effective_cache_size', { 'default_value' => '22GB' }),
    String  $maintenance_work_mem  = lookup('profile::maps::postgresql_common::maintenance_work_mem', { 'default_value' => '4GB' }),
    Integer $max_worker_processes  = lookup('profile::maps::postgresql_common::max_worker_processes', { 'default_value' => 8 }),
){

    class { '::postgresql::postgis': }

    $pgversion = $::lsbdistcodename ? {
        'buster'  => 11,
        'bullseye' => 13,
    }

    # Tuning
    file { "/etc/postgresql/${pgversion}/main/tuning.conf":
        ensure  => 'present',
        owner   => 'root',
        group   => 'root',
        mode    => '0444',
        content => template('profile/maps/tuning.conf.erb'),
    }

    sysctl::parameters { 'postgres_shmem':
        values => {
            # That is derived after tuning postgresql, deriving automatically is
            # not the safest idea yet.
            'kernel.shmmax' => 8388608000,
        },
    }

    ferm::service { 'kubepods-maps-postgres':
        proto  => 'tcp',
        port   => '5432',
        srange => '($WIKIKUBE_KUBEPODS_NETWORKS $STAGING_KUBEPODS_NETWORKS)',
    }
}