question Ambari setup erorr: Unable to start PostgreSQL server. Exiting in Archives of Support Questions (Read Only)

Ambari setup erorr: Unable to start PostgreSQL server. Exiting

mayank_rathi — Fri, 15 Sep 2017 01:35:01 GMT

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.rpm

and then ran following command to Setup Ambari:

sudo yum install ambari-server

Thanks!!

Re: Ambari setup erorr: Unable to start PostgreSQL server. Exiting

ssahi — Fri, 15 Sep 2017 01:56:45 GMT

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

Re: Ambari setup erorr: Unable to start PostgreSQL server. Exiting

ranjitsingh05 — Fri, 15 Sep 2017 02:07:17 GMT

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-default_databases_-_ambari.html

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

Re: Ambari setup erorr: Unable to start PostgreSQL server. Exiting

jsensharma — Fri, 15 Sep 2017 02:10:47 GMT

@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_ambari_with_postgresql.html

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).

Re: Ambari setup erorr: Unable to start PostgreSQL server. Exiting

mayank_rathi — Fri, 15 Sep 2017 08:33:23 GMT

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