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