Issues with connecting postgres (localhost) with latest odk central (v 2023.2)

Support
7

Hi @yanokwa, I have discovered an alternative method for connecting ODK Central to localhost Postgres. Here are the modifications I made:

Environment variable changes:

DB_HOST=192.X.X.X
DB_USER=odk
DB_PASSWORD=XXXX
DB_NAME=odk

Modifications in postgresql.conf:
listen_addresses ='localhost,192.X.X.X'

Modifications in pg_hba.conf:
host all all 172.0.0.0/8 md5

These adjustments have proven to be effective, and thanks for the support.

2 Likes