summaryrefslogtreecommitdiffstats
path: root/plugins/ompgsql
diff options
context:
space:
mode:
authorMarc Schiffbauer <marc.schiffbauer@mightycare.de>2010-02-08 14:20:15 +0100
committerRainer Gerhards <rgerhards@adiscon.com>2010-02-08 14:20:15 +0100
commit184d8cf6d27ea1753cc78b74b6d81a8433a6d59a (patch)
treee0f1523ca2d621d42bbcec72abb848ac96e7cff6 /plugins/ompgsql
parent85a0ed1ccefc9bf0d054dac0d5305b1f6cc0fe22 (diff)
downloadrsyslog-184d8cf6d27ea1753cc78b74b6d81a8433a6d59a.tar.gz
rsyslog-184d8cf6d27ea1753cc78b74b6d81a8433a6d59a.tar.xz
rsyslog-184d8cf6d27ea1753cc78b74b6d81a8433a6d59a.zip
improved PostgreSQL database create script, provided doc on PostgreSQL setup
Signed-off-by: Rainer Gerhards <rgerhards@adiscon.com>
Diffstat (limited to 'plugins/ompgsql')
-rw-r--r--plugins/ompgsql/createDB.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/plugins/ompgsql/createDB.sql b/plugins/ompgsql/createDB.sql
index facdcaa0..2f72a0a6 100644
--- a/plugins/ompgsql/createDB.sql
+++ b/plugins/ompgsql/createDB.sql
@@ -1,4 +1,4 @@
-CREATE DATABASE "Syslog";
+CREATE DATABASE 'Syslog' WITH ENCODING 'SQL_ASCII';
\c Syslog;
CREATE TABLE SystemEvents
(