From e78193d6848f9c61b8c8eabffef08c58a3bf64cb Mon Sep 17 00:00:00 2001
From: Boris Kolpackov <boris@codesynthesis.com>
Date: Thu, 27 Jun 2013 12:26:29 +0200
Subject: Update database setup instructions

---
 db/mysql/setup  | 3 +++
 db/oracle/setup | 2 ++
 db/pgsql/setup  | 9 ++++++++-
 3 files changed, 13 insertions(+), 1 deletion(-)

(limited to 'db')

diff --git a/db/mysql/setup b/db/mysql/setup
index 90044b0..3c4fb0a 100644
--- a/db/mysql/setup
+++ b/db/mysql/setup
@@ -4,6 +4,9 @@ bind-address = 0.0.0.0
 You may also need to open the 3306 port in the firewall
 (system-control-firewall on Fedora).
 
+From root login:
+
+mysql -p
 
 CREATE USER odb_test@'%';
 CREATE USER odb_test@'localhost';
diff --git a/db/oracle/setup b/db/oracle/setup
index 32af879..b3d9502 100644
--- a/db/oracle/setup
+++ b/db/oracle/setup
@@ -1,6 +1,8 @@
 $ su oracle
 $ sqlplus / as sysdba
 
+EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
+
 alter profile DEFAULT limit password_life_time UNLIMITED;
 
 CREATE USER odb_test
diff --git a/db/pgsql/setup b/db/pgsql/setup
index bb872ac..69beff1 100644
--- a/db/pgsql/setup
+++ b/db/pgsql/setup
@@ -16,6 +16,13 @@ host    odb_test        odb_test        192.168.0.0/24          trust
     create database odb_test;
     grant all privileges on database odb_test to odb_test;
 
-* If need to add hstore support:
+* If need to add hstore support (postgresql-contrib-X.Y package):
+
+  For 8.x:
 
   psql odb_test -f /usr/share/postgresql/8.4/contrib/hstore.sql
+
+  For 9.x:
+
+  psql odb_test
+    CREATE EXTENSION hstore;
-- 
cgit v1.1