From 7bb5176a0e1d3a7d8a119b92758404d514f59be9 Mon Sep 17 00:00:00 2001
From: Cullum Smith <cullum@sacredheartsc.com>
Date: Fri, 25 Oct 2024 00:49:42 -0400
Subject: icinga stuff

---
 lib/60-postgres | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'lib')

diff --git a/lib/60-postgres b/lib/60-postgres
index af37c27..6f418ea 100644
--- a/lib/60-postgres
+++ b/lib/60-postgres
@@ -17,8 +17,8 @@ EOF
 }
 
 postgres_create_database(){
-  # $1 = postgres_host, $2 = dbname, $3 = owner
+  # $1 = postgres_host, $2 = dbname, $3 = owner $4 = encoding, $5 = locale
   cat <<EOF | postgres_run -h "${1}" -d postgres
-SELECT 'CREATE DATABASE "${2}" OWNER "${3:-postgres}"' WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = '${2}')\\gexec
+SELECT 'CREATE DATABASE "${2}" ENCODING "${4:-UTF8}" LOCALE "${5:-en_US.UTF-8}" OWNER "${3:-postgres}" TEMPLATE "template0"' WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = '${2}')\\gexec
 EOF
 }
-- 
cgit v1.2.3