Hi,
there seems to be a problem with the sample createDB.sql provided for
ompgsql.
I've used postgresql-8.4.13-1.el6_3.x86_64, rsyslog v7-stable and got this:
--- 8< ---
$ psql -f /tmp/createDB.sql
psql:/tmp/createDB.sql:1: ERROR: syntax error at or near "'Syslog'"
LINE 1: CREATE DATABASE 'Syslog' WITH ENCODING 'SQL_ASCII';
^
psql:/tmp/createDB.sql:2: \connect: FATAL: database "Syslog" does not exist
--- 8< ---
This is the proposed change to fix it:
--- 8< ---
diff --git a/plugins/ompgsql/createDB.sql b/plugins/ompgsql/createDB.sql
index 2f72a0a..0c0f7e1 100644
--- a/plugins/ompgsql/createDB.sql
+++ b/plugins/ompgsql/createDB.sql
@@ -1,4 +1,4 @@
-CREATE DATABASE 'Syslog' WITH ENCODING 'SQL_ASCII';
+CREATE DATABASE "Syslog" WITH ENCODING 'SQL_ASCII' TEMPLATE template0;
\c Syslog;
CREATE TABLE SystemEvents
(
--- 8< ---
Anybody has any comments / suggestions?
Thanks,
Tomas
_______________________________________________
rsyslog mailing list
http://lists.adiscon.net/mailman/listinfo/rsyslog
http://www.rsyslog.com/professional-services/
What's up with rsyslog? Follow https://twitter.com/rgerhards
NOTE WELL: This is a PUBLIC mailing list, posts are ARCHIVED by a myriad of
sites beyond our control. PLEASE UNSUBSCRIBE and DO NOT POST if you DON'T LIKE
THAT.
