From f41f557e9af9d49fc29aab73b968fde380db80d1 Mon Sep 17 00:00:00 2001
From: "Jean-Marc Pigeon (Delson)" <jmp@safe.ca>
Date: Wed, 18 Jun 2025 13:07:21 -0400
Subject: [PATCH] Improving postgresql data-base creation

---
 conf/mailleur.conf | 5 +++--
 mailleur.spec.in   | 2 +-
 2 files changed, 4 insertions(+), 3 deletions(-)

diff --git a/conf/mailleur.conf b/conf/mailleur.conf
index 5a0e665..a6a451e 100644
--- a/conf/mailleur.conf
+++ b/conf/mailleur.conf
@@ -31,11 +31,12 @@ CA_KEY_CLT="./certs/localhost-key.pem"
 CA_VERIFY_CLT=0	#to check PEER/server remote certificate
 #------------------------------------------------
 #Configured for Postgresql database
-#DB_TYPE can be either POSTGRESQL,MYSQL
-DB_TYPE=TO_BE_DEFINED
+#DB_TYPE can be either POSTGRESQL,MYSQL, default POSTGRESQL
+DB_TYPE=POSTGRESQL
 DB_NAME=mailleur
 DB_HOST=localhost
 DB_PORT=5432
+DB_LANG="UTF-8"
 #------------------------------------------------
 #Dovecot storage directory
 DOV_MAILDIR="/var/spool/mailleur/mails"
diff --git a/mailleur.spec.in b/mailleur.spec.in
index 7ba6786..4249216 100644
--- a/mailleur.spec.in
+++ b/mailleur.spec.in
@@ -149,7 +149,7 @@ Obsoletes	:	%{name}-mysql		<= %{version}-%{release}
 %post			postgresql
 if [ "$1" = 1 ]; then
   sed -i					\
-	-e "s/DB_TO_BE_DEFINED/POSTGRESQL/"	\
+	-e "s/DB_TYPE=.*$/DB_TYPE=POSTGRESQL/"	\
 	%{_sysconfdir}/%{name}/%{name}.conf
   fi
 
-- 
2.47.3