Changeset View
Changeset View
Standalone View
Standalone View
site-modules/profile/manifests/postgresql/server.pp
Show First 20 Lines • Show All 103 Lines • ▼ Show 20 Lines | each($dbs) | $db_type, $db_config | { | ||||
) | ) | ||||
$db_name = $db_config['name'] | $db_name = $db_config['name'] | ||||
$db_user = $db_config['user'] | $db_user = $db_config['user'] | ||||
postgresql::server::db { $db_name: | postgresql::server::db { $db_name: | ||||
user => $db_user, | user => $db_user, | ||||
password => $db_pass, | password => $db_pass, | ||||
owner => $db_user, | owner => $db_user, | ||||
encoding => 'UTF8', | |||||
locale => 'C.UTF-8', | |||||
require => Class['postgresql::server'] | require => Class['postgresql::server'] | ||||
} | } | ||||
# guest user has read access on tables | # guest user has read access on tables | ||||
postgresql::server::database_grant { $db_name: | postgresql::server::database_grant { $db_name: | ||||
privilege => 'connect', | privilege => 'connect', | ||||
db => $db_name, | db => $db_name, | ||||
role => $guest, | role => $guest, | ||||
require => Postgresql::Server::Db[$db_name] | require => Postgresql::Server::Db[$db_name] | ||||
} | } | ||||
} | } | ||||
} | } |