- Pivotal Greenplum Database (GPDB) 4.2.x
- Operating System- Red Hat Enterprise Linux 6.x
Starting the Pivotal Greenplum using gpstart failed with below message:
20140523:18:21:53:307652 gpstart:mdw:gpadmin-[INFO]:-Starting Master instance in admin mode 20140523:18:21:55:307652 gpstart:mdw:gpadmin-[CRITICAL]:-Failed to start Master instance in admin mode 20140523:18:21:55:307652 gpstart:mdw:gpadmin-[CRITICAL]:-Error occurred: non-zero rc: 1 Command was: 'env GPSESSID=0000000000 GPERA=None $GPHOME/bin/pg_ctl -D /data/master/gpseg-1 -l /data/master/gpseg-1/pg_log/startup.log -w -t 600 -o " -p 5432 -b 1 -z 0 --silent-mode=true -i -M master -C -1 -x 66 -c gp_role=utility " start' rc=1, stdout='waiting for server to start......could not start server ', stderr='pg_ctl: PID file "/data/master/gpseg-1/postmaster.pid" does not exist '
Checking the master log at $MASTER_DATA_DIRECTORY/pg_log reports this message:
2014-05-23 18:21:53.860954 SGT,,,p307667,th-116709600,,,,0,,,seg-1,,,,,"LOG","F0000","invalid IP mask ""trust"": Name or service not known",,,,,"line 110 of configuration file ""/data/master/gpseg-1/pg_hba.conf""",,0,,"hba.c",992, 2014-05-23 18:21:53.861037 SGT,,,p307667,th-116709600,,,,0,,,seg-1,,,,,"FATAL","XX000","could not load pg_hba.conf",,,,,,,0,,"postmaster.c",1547,
As indicated by the message on the pg_logs, the file "/data/master/gpseg-1/pg_hba.conf" at line 110 has an invalid MASK for the IP address. The operation load/cache the pg_hba.conf in the memory is hence being aborted.
Checking the pg_hba.conf shows that the IP mask entry for line 110 was missing:
host all gpadmin 192.168.xx.xxx trust
- Please refer to this guide to see how to configure the pg_hba.conf.
- Fix the pg_hba.conf file after applying the CIDR-ADDRESS or adding IP MASK format to the incorrect record (here we have used CIDR-ADDRESS format).
host all gpadmin 192.168.xx.xxx/32 trust
- Attempt to start the database now: