summaryrefslogtreecommitdiffstats
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
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>
-rw-r--r--doc/src/rsyslog-pgsql.odtbin0 -> 41755 bytes
-rw-r--r--plugins/ompgsql/createDB.sql2
2 files changed, 1 insertions, 1 deletions
diff --git a/doc/src/rsyslog-pgsql.odt b/doc/src/rsyslog-pgsql.odt
new file mode 100644
index 00000000..5034c5fb
--- /dev/null
+++ b/doc/src/rsyslog-pgsql.odt
Binary files differ
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
(