From 327196eaee37984b6ea264efca7158b2adf5971a Mon Sep 17 00:00:00 2001 From: Michael Scherer Date: Tue, 7 Dec 2010 02:40:23 +0000 Subject: like the user type, add a database type --- modules/postgresql/manifests/init.pp | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'modules/postgresql/manifests/init.pp') diff --git a/modules/postgresql/manifests/init.pp b/modules/postgresql/manifests/init.pp index 9b9e3b18..6765c7e5 100644 --- a/modules/postgresql/manifests/init.pp +++ b/modules/postgresql/manifests/init.pp @@ -68,6 +68,14 @@ class postgresql { require => Package["postgresql-server"], } + # TODO convert it to a regular type ( so we can later change user and so on ) + define database($description="", $user="postgres") { + exec { "createdb -U postgres $name '$description'": + user => root, + unless => "psql -l -U postgres | grep '^$name|'", + } + } + define user($password) { $sql = "CREATE ROLE $name ENCRYPTED PASSWORD '$password' NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN;" -- cgit v1.2.1