modules/postgres/manifests/backup_cluster.pp

   1 #
   2 define postgres::backup_cluster(
   3   String $pg_version,
   4   String $pg_cluster = 'main',
   5   Integer $pg_port = 5432,
   6   String $db_backup_role = 'debian-backup',
   7   String $db_backup_role_password = hkdf('/etc/puppet/secret', "postgresql-${::hostname}-${$pg_cluster}-${pg_port}-backup_role}"),
   8   Boolean $do_role = false,
   9   Boolean $do_hba = false,
  10   $backup_servers = getfromhash($deprecated::roles, 'postgres_backup_server'),
  11 ) {
  12   $datadir = "/var/lib/postgresql/${pg_version}/${pg_cluster}"
  13   file { "${datadir}/.nobackup":
  14     content  => ''
  15   }
  16
  17   ## XXX - get these from the roles and ldap
  18   # backuphost, storace
  19   $backup_servers_addrs = ['5.153.231.12/32', '93.94.130.161/32', '2001:41c8:1000:21::21:12/128', '2a02:158:380:280::161/128']
  20   $backup_servers_addrs_joined = join($backup_servers_addrs, ' ')
  21
  22   if $do_role {
  23     postgresql::server::role { $db_backup_role:
  24       password_hash => postgresql_password($db_backup_role, $db_backup_role_password),
  25       replication   => true,
  26     }
  27   }
  28   if $do_hba {
  29     $backup_servers_addrs.each |String $address| {
  30       postgresql::server::pg_hba_rule { "debian_backup-${address}":
  31         description => 'Open up PostgreSQL for backups',
  32         type        => 'hostssl',
  33         database    => 'replication',
  34         user        => $db_backup_role,
  35         address     => $address,
  36         auth_method => 'md5',
  37       }
  38     }
  39   }
  40   ferm::rule { "dsa-postgres-${pg_port}":
  41     description => 'Allow postgress access from backup host',
  42     domain      => '(ip ip6)',
  43     rule        => "&SERVICE_RANGE(tcp, ${pg_port}, ( @ipfilter((${backup_servers_addrs_joined})) ))",
  44   }
  45
  46   postgres::backup_server::register_backup_cluster { "backup-role-${::fqdn}}-${pg_port}":
  47     pg_port     => $pg_port,
  48     pg_role     => $db_backup_role,
  49     pg_password => $db_backup_role_password,
  50     pg_cluster  => $pg_cluster,
  51     pg_version  => $pg_version,
  52   }
  53 }