modules/role/manifests/cryptoportfolio/postgresql.pp

   1 class role::cryptoportfolio::postgresql inherits role::cryptoportfolio {
   2   $password_seed = lookup("base_installation::puppet_pass_seed")
   3
   4   $pg_password = generate_password(24, $password_seed, "postgres_cryptoportfolio")
   5
   6   profile::postgresql::master { "postgresql master for cryptoportfolio":
   7     letsencrypt_host => $web_host,
   8     backup_hosts     => ["backup-1"],
   9   }
  10
  11   postgresql::server::db { $pg_db:
  12     user     =>  $pg_user,
  13     password =>  postgresql_password($pg_user, $pg_password),
  14   }
  15
  16   postgresql::server::pg_hba_rule { 'allow local access to cryptoportfolio user':
  17     type        => 'local',
  18     database    => $pg_db,
  19     user        => $pg_user,
  20     auth_method => 'ident',
  21     order       => "05-01",
  22   }
  23
  24 }