1 files changed, 20 insertions, 0 deletions
diff --git a/modules/postgresql/manifests/database.pp b/modules/postgresql/manifests/database.pp
new file mode 100644
index 00000000..34cee2a6
--- /dev/null
+++ b/modules/postgresql/manifests/database.pp
@@ -0,0 +1,20 @@
+# TODO convert it to a regular type ( so we can later change user and so on )
+define postgresql::database($description = '',
+                            $user = 'postgres',
+                            $callback_notify = '') {
+
+    exec { "createdb -O ${user} -U postgres ${name} '${description}' ":
+        user    => 'root',
+        unless  => "psql -A -t -U postgres -l | grep '^${name}|'",
+        require => Service['postgresql'],
+    }
+
+    # this is fetched by the manifest asking the database creation,
+    # once the db have been created
+    # FIXME proper ordering ?
+    # FIXME In puppet >3.0 word 'tag' is reserved, so it has to be renamed
+    @@postgresql::database_callback { $name:
+        tag             => $name,
+        callback_notify => $callback_notify,
+    }
+}