db/pgsql/setup


1
2
3
4
5
6
7
8
9
10
11
12
13
14
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 and database:

  su postgres
  psql
    create user odb_test;
    create database odb_test;
    grant all privileges on database odb_test to odb_test;