diff options
Diffstat (limited to 'zarb-ml/mageia-sysadm/2010-December/001043.html')
-rw-r--r-- | zarb-ml/mageia-sysadm/2010-December/001043.html | 91 |
1 files changed, 91 insertions, 0 deletions
diff --git a/zarb-ml/mageia-sysadm/2010-December/001043.html b/zarb-ml/mageia-sysadm/2010-December/001043.html new file mode 100644 index 000000000..00d5f22e9 --- /dev/null +++ b/zarb-ml/mageia-sysadm/2010-December/001043.html @@ -0,0 +1,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> |