Add instructions on setting up PostgreSQL for ODB testing

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;