create salsa database with puppet
[mirror/dsa-puppet.git] / modules / salsa / manifests / database.pp
1 #
2 class salsa::database inherits salsa {
3         include postgresql::server
4         ensure_packages ( "postgresql-contrib-9.6", { ensure => 'installed' })
5
6         postgresql::server::db { $salsa::db_name:
7                 user     => $salsa::db_role,
8                 password => postgresql_password($salsa::db_role, $salsa::db_password),
9         }
10
11         postgresql::server::extension { 'pg_trgm':
12                 database => $salsa::db_name,
13                 require => Package['postgresql-contrib-9.6'],
14         }
15
16         # XXX set up backups
17         file { "/var/lib/postgresql/9.6/main/.nobackup":
18                 content  => ""
19         }
20 }