Ambari setup erorr: Unable to start PostgreSQL server. Exiting

[#1]

Hello All,

I am getting below error while installing Ambari. How do I resolve this?

Completing setup...
Configuring database...
Enter advanced database configuration [y/n] (n)? n
Configuring database...
Default properties detected. Using built-in database.
Configuring ambari database...
Checking PostgreSQL...
Running initdb: This may take up to a minute.
About to start PostgreSQL
[sudo] password for kfkadm:
ERROR: Exiting with exit code 3.
REASON: Unable to start PostgreSQL server. Exiting

I had installed PostgreSQL by running below command:

sudo yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-redhat96-9.6-3.noarch.rp...

and then ran following command to Setup Ambari:

sudo yum install ambari-server

Thanks!!

[#2]

Hi @M R

I think if you are using the built-in database, which it appears are you trying to use, you likely do not need to install the postgres db manually. Ambari can do this for you. I suspect because you have installed it outside of Ambari, there is a conflict. I would try removing the manual postgres rpm based installation, and re-run the ambari-server setup

[#3]

If you want to use the existing postgres db make sure it been setup already before running the ambari-server setup.

Link:

https://docs.hortonworks.com/HDPDocuments/Ambari-2.5.2.0/bk_ambari-administration/content/using_non-...

Otherwise , as Sonu said, remove the rpm of postgres and have ambari manage its postgres db.

[#4 · Accepted solution]

@M R

As you downloaded your own version of Postgres, So you will need to perform some additional steps on your PostgresSQL before you start using it with Ambari.

https://docs.hortonworks.com/HDPDocuments/Ambari-2.5.1.0/bk_ambari-administration/content/using_amba...

.

The above link talks about how you can use your own version of Postgres with AmbariServer. (else in Embedded Postgres Mode Ambari Server will create the schema on it's own).

.

After following the above link you can run the ambari-server setup and this time you will need to choose "

Enter advanced database configuration [y/n] (n)? y" and then choose the Option 4 [PostgresSql] (Please do not choose Option 1 Embedded Postgres).

.

[#5]

Thank you all. All 3 answers were correct and pointed me in right direction.