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

Install Postgres

Before You Begin

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

[Warning]Warning

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.

Steps

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

    yum install https://yum.postgresql.org/9.6/redhat/rhel-7-x86_64/pgdg-redhat96-9.6-3.noarch.rpm
  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
    psql