summaryrefslogtreecommitdiff
path: root/db/pgsql
diff options
context:
space:
mode:
authorBoris Kolpackov <boris@codesynthesis.com>2011-10-04 16:32:19 +0200
committerBoris Kolpackov <boris@codesynthesis.com>2011-10-04 16:32:19 +0200
commit5f22209cd002fd925ab134178157616fed9ea92b (patch)
treec9605dfcaa3a1fa8d6bd270c7343eb26c505fbf9 /db/pgsql
parent3f8b0a2bbd87017750199949bfd61dd99dde34f1 (diff)
Add instructions on setting up PostgreSQL for ODB testing
Diffstat (limited to 'db/pgsql')
-rw-r--r--db/pgsql/setup15
1 files changed, 15 insertions, 0 deletions
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;