From 184d8cf6d27ea1753cc78b74b6d81a8433a6d59a Mon Sep 17 00:00:00 2001 From: Marc Schiffbauer Date: Mon, 8 Feb 2010 14:20:15 +0100 Subject: improved PostgreSQL database create script, provided doc on PostgreSQL setup Signed-off-by: Rainer Gerhards --- doc/src/rsyslog-pgsql.odt | Bin 0 -> 41755 bytes plugins/ompgsql/createDB.sql | 2 +- 2 files changed, 1 insertion(+), 1 deletion(-) create mode 100644 doc/src/rsyslog-pgsql.odt diff --git a/doc/src/rsyslog-pgsql.odt b/doc/src/rsyslog-pgsql.odt new file mode 100644 index 00000000..5034c5fb Binary files /dev/null and b/doc/src/rsyslog-pgsql.odt 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 ( -- cgit