https://community.cloudera.com/t5/Support-Questions/unable-to-start-postgres-for-ambari/m-p/154324#M116780 <P>login as <STRONG>root</STRONG> </P> <PRE>[root@Node0 ~]$ [root@Node0 ~]$ cd /var/lib/pgsql [root@Node0 ~]$ su - postgres [root@Node0 pgsql]$ sudo su - postgres -bash-4.2 $ grep listen /var/lib/pgsql/data/postgresql.conf #listen_addresses = 'localhost' # what IP address(es) to listen on; </PRE><PRE>-bash-4.2 $ vi /var/lib/pgsql/data_bkp/postgresql.conf </PRE><P> Find <STRONG>listen_address= 'localhost'</STRONG> and change to l<STRONG>ocal_address='*'</STRONG>, then and exit vi, then <STRONG>exit</STRONG> back to <EM>root.</EM></P> <PRE>service postgresql restart </PRE><P> Redirecting to /bin/systemctl restart postgresql.service</P><PRE>[root@Node0 ~]$ ambari-server setup</PRE><P><EM>and accept all prompts, and when ambari-server setup will successfully complete,</EM></P><PRE>[root@Node0 ~]$ ambari-server start </PRE><P><STRONG>Ambari Server 'start' completed successfully.</STRONG></P> Sun, 09 Apr 2017 02:27:37 GMT adaher 2017-04-09T02:27:37Z