1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<TITLE> [Mageia-sysadm] [525] like the user type, add a database type
</TITLE>
<LINK REL="Index" HREF="index.html" >
<LINK REL="made" HREF="mailto:mageia-sysadm%40mageia.org?Subject=Re%3A%20%5BMageia-sysadm%5D%20%5B525%5D%20like%20the%20user%20type%2C%20add%20a%20database%20type&In-Reply-To=%3C20101207024024.0A30A3FE29%40valstar.mageia.org%3E">
<META NAME="robots" CONTENT="index,nofollow">
<META http-equiv="Content-Type" content="text/html; charset=us-ascii">
<LINK REL="Previous" HREF="001042.html">
<LINK REL="Next" HREF="001044.html">
</HEAD>
<BODY BGCOLOR="#ffffff">
<H1>[Mageia-sysadm] [525] like the user type, add a database type</H1>
<B>root at mageia.org</B>
<A HREF="mailto:mageia-sysadm%40mageia.org?Subject=Re%3A%20%5BMageia-sysadm%5D%20%5B525%5D%20like%20the%20user%20type%2C%20add%20a%20database%20type&In-Reply-To=%3C20101207024024.0A30A3FE29%40valstar.mageia.org%3E"
TITLE="[Mageia-sysadm] [525] like the user type, add a database type">root at mageia.org
</A><BR>
<I>Tue Dec 7 03:40:24 CET 2010</I>
<P><UL>
<LI>Previous message: <A HREF="001042.html">[Mageia-sysadm] [524] add a type postgres user, to be able to declare postgresql user in puppet directly
</A></li>
<LI>Next message: <A HREF="001044.html">[Mageia-sysadm] [526] - move the postgresql server bits to a subclass
</A></li>
<LI> <B>Messages sorted by:</B>
<a href="date.html#1043">[ date ]</a>
<a href="thread.html#1043">[ thread ]</a>
<a href="subject.html#1043">[ subject ]</a>
<a href="author.html#1043">[ author ]</a>
</LI>
</UL>
<HR>
<!--beginarticle-->
<PRE>Revision: 525
Author: misc
Date: 2010-12-07 03:40:23 +0100 (Tue, 07 Dec 2010)
Log Message:
-----------
like the user type, add a database type
Modified Paths:
--------------
puppet/modules/postgresql/manifests/init.pp
Modified: puppet/modules/postgresql/manifests/init.pp
===================================================================
--- puppet/modules/postgresql/manifests/init.pp 2010-12-07 02:40:22 UTC (rev 524)
+++ puppet/modules/postgresql/manifests/init.pp 2010-12-07 02:40:23 UTC (rev 525)
@@ -68,6 +68,14 @@
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;"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/mageia-sysadm/attachments/20101207/97c35e94/attachment.html>
</PRE>
<!--endarticle-->
<HR>
<P><UL>
<!--threads-->
<LI>Previous message: <A HREF="001042.html">[Mageia-sysadm] [524] add a type postgres user, to be able to declare postgresql user in puppet directly
</A></li>
<LI>Next message: <A HREF="001044.html">[Mageia-sysadm] [526] - move the postgresql server bits to a subclass
</A></li>
<LI> <B>Messages sorted by:</B>
<a href="date.html#1043">[ date ]</a>
<a href="thread.html#1043">[ thread ]</a>
<a href="subject.html#1043">[ subject ]</a>
<a href="author.html#1043">[ author ]</a>
</LI>
</UL>
<hr>
<a href="https://www.mageia.org/mailman/listinfo/mageia-sysadm">More information about the Mageia-sysadm
mailing list</a><br>
</body></html>
|
