1 # Define for conveniently creating a role, database and assigning the correct
2 # permissions. See README.md for more details.
3 define postgresql::server::db (
8 $encoding = $postgresql::server::encoding,
9 $locale = $postgresql::server::locale,
12 $template = 'template0',
17 if ! defined(Postgresql::Server::Database[$dbname]) {
18 postgresql::server::database { $dbname:
20 encoding => $encoding,
21 tablespace => $tablespace,
22 template => $template,
24 istemplate => $istemplate,
29 if ! defined(Postgresql::Server::Role[$user]) {
30 postgresql::server::role { $user:
31 password_hash => $password,
32 before => Postgresql::Server::Database[$dbname],
36 if ! defined(Postgresql::Server::Database_grant["GRANT ${user} - ${grant} - ${dbname}"]) {
37 postgresql::server::database_grant { "GRANT ${user} - ${grant} - ${dbname}":
41 } -> Postgresql_conn_validator<| db_name == $dbname |>
44 if($tablespace != undef and defined(Postgresql::Server::Tablespace[$tablespace])) {
45 Postgresql::Server::Tablespace[$tablespace]->Postgresql::Server::Database[$name]