diff options
Diffstat (limited to 'zarb-ml/mageia-sysadm/2010-December/001042.html')
| -rw-r--r-- | zarb-ml/mageia-sysadm/2010-December/001042.html | 90 |
1 files changed, 90 insertions, 0 deletions
diff --git a/zarb-ml/mageia-sysadm/2010-December/001042.html b/zarb-ml/mageia-sysadm/2010-December/001042.html new file mode 100644 index 000000000..58c2e4929 --- /dev/null +++ b/zarb-ml/mageia-sysadm/2010-December/001042.html @@ -0,0 +1,90 @@ +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> +<HTML> + <HEAD> + <TITLE> [Mageia-sysadm] [524] add a type postgres user, to be able to declare postgresql user in puppet directly + </TITLE> + <LINK REL="Index" HREF="index.html" > + <LINK REL="made" HREF="mailto:mageia-sysadm%40mageia.org?Subject=Re%3A%20%5BMageia-sysadm%5D%20%5B524%5D%20add%20a%20type%20postgres%20user%2C%0A%20to%20be%20able%20to%20declare%20postgresql%20user%20in%20puppet%20directly&In-Reply-To=%3C20101207024022.BD0863FE29%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="001041.html"> + <LINK REL="Next" HREF="001043.html"> + </HEAD> + <BODY BGCOLOR="#ffffff"> + <H1>[Mageia-sysadm] [524] add a type postgres user, to be able to declare postgresql user in puppet directly</H1> + <B>root at mageia.org</B> + <A HREF="mailto:mageia-sysadm%40mageia.org?Subject=Re%3A%20%5BMageia-sysadm%5D%20%5B524%5D%20add%20a%20type%20postgres%20user%2C%0A%20to%20be%20able%20to%20declare%20postgresql%20user%20in%20puppet%20directly&In-Reply-To=%3C20101207024022.BD0863FE29%40valstar.mageia.org%3E" + TITLE="[Mageia-sysadm] [524] add a type postgres user, to be able to declare postgresql user in puppet directly">root at mageia.org + </A><BR> + <I>Tue Dec 7 03:40:22 CET 2010</I> + <P><UL> + <LI>Previous message: <A HREF="001041.html">[Mageia-sysadm] [523] add a require on a required package, needed to create initial database +</A></li> + <LI>Next message: <A HREF="001043.html">[Mageia-sysadm] [525] like the user type, add a database type +</A></li> + <LI> <B>Messages sorted by:</B> + <a href="date.html#1042">[ date ]</a> + <a href="thread.html#1042">[ thread ]</a> + <a href="subject.html#1042">[ subject ]</a> + <a href="author.html#1042">[ author ]</a> + </LI> + </UL> + <HR> +<!--beginarticle--> +<PRE>Revision: 524 +Author: misc +Date: 2010-12-07 03:40:22 +0100 (Tue, 07 Dec 2010) +Log Message: +----------- +add a type postgres user, to be able to declare postgresql user in puppet directly + +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:21 UTC (rev 523) ++++ puppet/modules/postgresql/manifests/init.pp 2010-12-07 02:40:22 UTC (rev 524) +@@ -67,4 +67,13 @@ + content => template("postgresql/pg_ident.conf"), + require => Package["postgresql-server"], + } ++ ++ define user($password) { ++ $sql = "CREATE ROLE $name ENCRYPTED PASSWORD '$password' NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN;" ++ ++ exec { "psql -U postgres -c \"$sql\" ": ++ user => root, ++ unless => "psql -A -t -U postgres -c '\du $name' | grep '$name'", ++ } ++ } + } +-------------- next part -------------- +An HTML attachment was scrubbed... +URL: </pipermail/mageia-sysadm/attachments/20101207/7c5ec8f0/attachment.html> +</PRE> + + + + +<!--endarticle--> + <HR> + <P><UL> + <!--threads--> + <LI>Previous message: <A HREF="001041.html">[Mageia-sysadm] [523] add a require on a required package, needed to create initial database +</A></li> + <LI>Next message: <A HREF="001043.html">[Mageia-sysadm] [525] like the user type, add a database type +</A></li> + <LI> <B>Messages sorted by:</B> + <a href="date.html#1042">[ date ]</a> + <a href="thread.html#1042">[ thread ]</a> + <a href="subject.html#1042">[ subject ]</a> + <a href="author.html#1042">[ 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> |