From 5f22209cd002fd925ab134178157616fed9ea92b Mon Sep 17 00:00:00 2001
From: Boris Kolpackov <boris@codesynthesis.com>
Date: Tue, 4 Oct 2011 16:32:19 +0200
Subject: Add instructions on setting up PostgreSQL for ODB testing

---
 db/pgsql/setup | 15 +++++++++++++++
 1 file changed, 15 insertions(+)
 create mode 100644 db/pgsql/setup

(limited to 'db')

diff --git a/db/pgsql/setup b/db/pgsql/setup
new file mode 100644
index 0000000..49309d5
--- /dev/null
+++ b/db/pgsql/setup
@@ -0,0 +1,15 @@
+* In /etc/postgresql/X.Y/pg_hba.conf add the following two lines after
+  the "local all postgres ..." line:
+
+local   odb_test        odb_test                                trust
+host    odb_test        odb_test        192.168.0.0/24          trust
+
+  Restart the server.
+
+* Add user are database:
+
+  su postgres
+  psql
+    create user odb_test;
+    create database odb_test;
+    grant all privileges on database odb_test to odb_test;
-- 
cgit v1.1