blob: 7b193cc60e6a33cf222ccc303b965085be04dc3e (
plain)
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
29
30
31
32
33
34
35
36
|
STEP 1: Set up the pg_hba.conf file like this:
--- BEGIN --------------------------------------------------------------
[...]
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all postgres trust
local bm bmuser trust
local all all md5
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
# Remote admin client (typically using pgadmin3):
# barbarella (jasplin's linux box):
host all postgres 172.24.90.79/32 md5
# Remote clients intended to access the 'bm' database as the 'bmuser' role without password:
host bm bmuser 172.24.90.79/32 trust # barbarella (jasplin's Linux box)
[additional remote clients ...]
--- END --------------------------------------------------------------
STEP 2: Run the reset.py script to initialize an empty database.
STEP 3: Run the reset-ranking.py script to initialize an empty 'ranking'
table.
NOTE: For now this is kept as a separate script in order not
to affect other tables. When the ranking feature has matured,
everything should be merged into the reset.py script.
|
