summaryrefslogtreecommitdiff
path: root/db/pgsql
diff options
context:
space:
mode:
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;