db/pgsql/setup


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28

* 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

* In /etc/postgresql/X.Y/postgresql.conf change listen_address to '*'.

  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;

* If need to add hstore support (postgresql-contrib-X.Y package):

  For 8.x:

  psql odb_test -f /usr/share/postgresql/8.4/contrib/hstore.sql

  For 9.x:

  psql odb_test
    CREATE EXTENSION hstore;