Cloudera Docs

Install Postgres

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

  1. Install Red Hat Package Manager (RPM) according to the requirements of your operating system: 
    yum install https://yum.postgresql.org/9.6/redhat/rhel-7-x86_64/repoview/postgresql96.html
  2. Install Postgres version 9.5 or later: 
    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