Given that postgres 8.4 is rather old, can you confirm that this is still needed
(and still works) with current versions?
8.4.16 is still supported, but it's the oldest version supported.
David Lang
On Thu, 28 Mar 2013, Tomas Heinrich wrote:
Date: Thu, 28 Mar 2013 16:26:11 +0100
From: Tomas Heinrich <[email protected]>
Reply-To: rsyslog-users <[email protected]>
To: rsyslog-users <[email protected]>
Subject: [rsyslog] ompgsql/createDB.sql issue
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.
_______________________________________________
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.
