Installing HDF Services on a New HDP Cluster
Also available as:
loading table of contents...

Install Postgres

Before You Begin

If you have already installed a MySQL database, you may skip these steps.


You must install Postgres 9.5 or later for SAM and Schema Registry. Ambari does not install Postgres 9.5, so you must perform a manual Postgres installation.


  1. Install RPM according to the requirements of your operating system:

    yum install
  2. Install 9.5+ Postgres database:

    yum install postgresql96-server postgresql96-contrib postgresql96
  3. Initialize the database:

    • For CentOS 7, use the following syntax:

      /usr/pgsql-9.6/bin/postgresql96-setup initdb
    • For CentOS 6, use the following syntax:

      sudo service postgresql initdb
  4. Start Postgres.

    For example, if you are using CentOS 7, use the following syntax:

    systemctl enable postgresql-9.6.service
    systemctl start postgresql-9.6.service 
  5. Verify that you can log in:

    sudo su postgres