Postgresql for Ambari not starting

[#1]

Dec 24 19:45:45 tspanndev13.field.hortonworks.com systemd[1]: Failed to start PostgreSQL database server. -- Subject: Unit postgresql.service has failed -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit postgresql.service has failed. -- -- The result is failed. Dec 24 19:45:45 tspanndev13.field.hortonworks.com systemd[1]: Unit postgresql.service entered failed state. Dec 24 19:45:45 tspanndev13.field.hortonworks.com systemd[1]: postgresql.service failed. Dec 24 19:45:45 tspanndev13.field.hortonworks.com polkitd[2452]: Unregistered Authentication Agent for unix-process:4241:769952344 (system bus name :1.8767, object path /org/freedesktop/PolicyKit1/Authent [root@tspannde

[#2 · Accepted solution]

try some of the option documented here

https://community.hortonworks.com/questions/41355/unable-to-start-postgres-for-ambari.html

[#3]

@Timothy Spann

You may be running into an SELinux issue. Tail /var/log/messages when you try to start Postgresql to see if you can get more information on the problem.

[#4]

had to uninstall ambari

Then I manually installed postgresql, chmod on the directories and ran sysctl enable and started postgresql