Troubleshooting
Problem
Symptom
NPS did not start. To get a better understanding of how much progress nzstart made before exiting, you ran the following two commands:
nzstart –i
tail -f /nz/kit/log/postgres/pg.log
The following output appeared:
2009-08-25 06:52:27.868934 EDT [30640] DEBUG: connection failed: host=127.0.0.1 user=ADMIN database=SYSTEM error=No pg_hba.conf entry for host localhost, user ADMIN, database SYSTEM
2009-08-25 06:52:28.876888 EDT [30640] DEBUG: connection failed: host=127.0.0.1 user=ADMIN database=SYSTEM error=No pg_hba.conf entry for host localhost, user ADMIN, database SYSTEM
Diagnosing The Problem
The likely cause of this problem is an incorrectly modified /nz/data/pg_hba.conf file.
Resolving The Problem
For nzstart to make a connection to the database, the following line must be in the /nz/data/pg_hba.conf file:
# NZ - we need to allow trusted admin commands to connect freely when
# run as the db owner. We enforce security by making sure the unix
# socket file is writable ONLY by the db owner. See postgresql.conf,
# where we set unix_socket_permissions = 0700.
local all trust
In addition, the pg_hba.conf file must be readable by the nz user. The expected permissions of this file are as follows:
-rw------- 1 nz nz 8543 Aug 25 06:53 pg_hba.conf
Historical Number
NZ045848
Was this topic helpful?
Document Information
More support for:
IBM PureData System
Software version:
1.0.0
Document number:
463611
Modified date:
17 October 2019
UID
swg21571389