blob: e091f22870a2507ad1bda905dbd4e788d6cddfe8 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
* 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;
* If need to add hstore support:
psql odb_test -f /usr/share/postgresql/8.4/contrib/hstore.sql
|
