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
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<TITLE> [Mageia-sysadm] [773] add various comment on what should be improved later
</TITLE>
<LINK REL="Index" HREF="index.html" >
<LINK REL="made" HREF="mailto:mageia-sysadm%40mageia.org?Subject=Re%3A%20%5BMageia-sysadm%5D%20%5B773%5D%20add%20various%20comment%20on%20what%20should%20be%0A%09improved%20later&In-Reply-To=%3C20110113181223.0743942375%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="002046.html">
<LINK REL="Next" HREF="002048.html">
</HEAD>
<BODY BGCOLOR="#ffffff">
<H1>[Mageia-sysadm] [773] add various comment on what should be improved later</H1>
<B>root at mageia.org</B>
<A HREF="mailto:mageia-sysadm%40mageia.org?Subject=Re%3A%20%5BMageia-sysadm%5D%20%5B773%5D%20add%20various%20comment%20on%20what%20should%20be%0A%09improved%20later&In-Reply-To=%3C20110113181223.0743942375%40valstar.mageia.org%3E"
TITLE="[Mageia-sysadm] [773] add various comment on what should be improved later">root at mageia.org
</A><BR>
<I>Thu Jan 13 19:12:22 CET 2011</I>
<P><UL>
<LI>Previous message: <A HREF="002046.html">[Mageia-sysadm] [293] adjust score style
</A></li>
<LI>Next message: <A HREF="002048.html">[Mageia-sysadm] [774] - allow to override the templates used for zone
</A></li>
<LI> <B>Messages sorted by:</B>
<a href="date.html#2047">[ date ]</a>
<a href="thread.html#2047">[ thread ]</a>
<a href="subject.html#2047">[ subject ]</a>
<a href="author.html#2047">[ author ]</a>
</LI>
</UL>
<HR>
<!--beginarticle-->
<PRE>Revision: 773
Author: misc
Date: 2011-01-13 19:12:22 +0100 (Thu, 13 Jan 2011)
Log Message:
-----------
add various comment on what should be improved later
Modified Paths:
--------------
puppet/modules/postgresql/manifests/init.pp
Modified: puppet/modules/postgresql/manifests/init.pp
===================================================================
--- puppet/modules/postgresql/manifests/init.pp 2011-01-12 22:58:33 UTC (rev 772)
+++ puppet/modules/postgresql/manifests/init.pp 2011-01-13 18:12:22 UTC (rev 773)
@@ -57,6 +57,9 @@
require => Package["postgresql-server"],
}
+ # TODO use augeas to manage this file once augeas 0.7.4 is installed
+ # on our server, as this would allow use to autodeclare database in it without
+ # much trouble
file { 'pg_hba.conf':
path => "$pgsql_data/pg_hba.conf",
ensure => present,
@@ -77,6 +80,8 @@
require => Package["postgresql-server"],
}
+ # TODO add a system of tag so we can declare database on more than one
+ # server
Postgresql::User <<| |>>
Postgresql::Database <<| |>>
}
@@ -89,7 +94,9 @@
unless => "psql -A -t -U postgres -l | grep '^$name|'",
}
}
-
+
+ # TODO convert to a regular type, so we can later change password without erasing the
+ # current user
define user($password) {
$sql = "CREATE ROLE $name ENCRYPTED PASSWORD '\$pass' NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN;"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/mageia-sysadm/attachments/20110113/713890f8/attachment.html>
</PRE>
<!--endarticle-->
<HR>
<P><UL>
<!--threads-->
<LI>Previous message: <A HREF="002046.html">[Mageia-sysadm] [293] adjust score style
</A></li>
<LI>Next message: <A HREF="002048.html">[Mageia-sysadm] [774] - allow to override the templates used for zone
</A></li>
<LI> <B>Messages sorted by:</B>
<a href="date.html#2047">[ date ]</a>
<a href="thread.html#2047">[ thread ]</a>
<a href="subject.html#2047">[ subject ]</a>
<a href="author.html#2047">[ 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>
|