Revision b22f96ff
Added by Ewoud Kohl van Wijngaarden over 10 years ago
| manifests/database/postgresql.pp | ||
|---|---|---|
|
cwd => '/',
|
||
|
}
|
||
|
|
||
|
include postgresql::client, postgresql::server, postgresql::params
|
||
|
|
||
|
if ! defined(Postgresql::Database_user[$foreman::db_username]) {
|
||
|
postgresql::database_user { $foreman::db_username:
|
||
|
password_hash => $password,
|
||
|
require => Class['postgresql::server'],
|
||
|
before => Postgresql::Database[$dbname],
|
||
|
}
|
||
|
}
|
||
|
|
||
|
$grant = 'ALL'
|
||
|
# TODO copied from puppetlabs-postgresql 2.3.0 manifests/db.pp
|
||
|
# should be removed by db once they expose owner parameter
|
||
|
postgresql::database { $dbname:
|
||
|
charset => $postgresql::params::charset,
|
||
|
tablespace => undef,
|
||
|
require => Class['postgresql::server'],
|
||
|
locale => $postgresql::params::locale,
|
||
|
owner => $foreman::db_username,
|
||
|
include postgresql::client, postgresql::server
|
||
|
postgresql::server::db { $dbname:
|
||
|
user => $foreman::db_username,
|
||
|
password => $password,
|
||
|
owner => $foreman::db_username,
|
||
|
}
|
||
|
|
||
|
postgresql::database_grant { "GRANT ${$foreman::db_username} - ${grant} - ${dbname}":
|
||
|
privilege => $grant,
|
||
|
db => $dbname,
|
||
|
role => $foreman::db_username,
|
||
|
require => [Postgresql::Database[$dbname], Postgresql::Database_user[$foreman::db_username]],
|
||
|
}
|
||
|
Postgresql::Server::Role[$foreman::db_username] -> Postgresql::Server::Database[$dbname]
|
||
|
}
|
||
Also available in: Unified diff
Work with puppetlabs-postgresql version 3+
This drops support for puppet 2.6.