1 files changed, 32 insertions, 0 deletions
diff --git a/tests/pgsql-template.sh b/tests/pgsql-template.sh
new file mode 100755
index 0000000..13e345c
--- /dev/null
+++ b/tests/pgsql-template.sh
@@ -0,0 +1,32 @@
+#!/bin/bash
+# This file is part of the rsyslog project, released under GPLv3
+
+. ${srcdir:=.}/diag.sh init
+
+psql -h localhost -U postgres -f testsuites/pgsql-basic.sql
+
+generate_conf
+add_conf '
+# putting the message in the SyslogTag field, so we know the template is actually used
+$template mytemplate,"insert into SystemEvents (SysLogTag) values '
+add_conf "('%msg%')"
+add_conf '",STDSQL
+
+$ModLoad ../plugins/ompgsql/.libs/ompgsql
+:msg, contains, "msgnum:" :ompgsql:127.0.0.1,syslogtest,postgres,testbench;mytemplate
+'
+startup
+injectmsg  0 5000
+shutdown_when_empty
+wait_shutdown 
+
+# we actually put the message in the SysLogTag field, so we know it doesn't use the default
+# template, like in pgsql-basic
+psql -h localhost -U postgres -d syslogtest -f testsuites/pgsql-select-syslogtag.sql -t -A > $RSYSLOG_OUT_LOG 
+
+seq_check  0 4999
+
+echo cleaning up test database
+psql -h localhost -U postgres -c 'DROP DATABASE IF EXISTS syslogtest;'
+
+exit_test