question Re: unable to start postgres for ambari in Support Questions

question Re: unable to start postgres for ambari in Support Questions https://community.cloudera.com/t5/Support-Questions/unable-to-start-postgres-for-ambari/m-p/154326#M116782 <PRE>ambari-server start</PRE>On running the above command, I was encountering the same error while starting Ambari-server, where ambari failed to start the Postgresql server with error 3.I figured out the following solution to start ambari-server. You can check the status using <PRE>service postgresql status </PRE> This gives the status of the service running as PostgreSQL. In case this is giving the error that the service is not running and the server failed to start, you can check the reason with the following commands: <PRE>systemctl status postgresql.service </PRE> If the reasons show anything related to the port and the listener like:<img src="https://community.cloudera.com/t5/image/serverpage/image-id/20993iE46469BDDA8D1035/image-size/medium?v=v2&px=400" role="button" title="45631-capture.jpg" alt="45631-capture.jpg" />Then navigate to the following path and check the versions:<PRE>ls /var/lib/pgsql</PRE>In case you find other folders like 9.6 or 9.5, for example, 9.6, then try and check if postgresql-9.6 is running.<PRE>service postgresql-9.6 status systemctl status postgresql-9.6.service </PRE>In case you find that this is running, you will have to stop the service and chkconfig it to off.<PRE>service postgresql-9.6 stop chkconfig postgresql-9.6 off</PRE>Try and restart the ambari-server now and this might work, as the ambari server tries to start the postgresql using /var/lib/pgsql/data/postgresql.conf and not the 9.6 version configuration. In order to stop facilitate the server to use the default configuration, we have to stop the server on 9.6 version or point ambari to 9.6 version pgsql.<PRE>ambari-server start ambari-server status</PRE> Sun, 18 Aug 2019 12:32:44 GMT sirisha_gadwala 2019-08-18T12:32:44Z