Cloudera Docs

Installing PostgreSQL

Learn how to install a PostgreSQL external database for use with NiFi Registry.

If you have already installed a MySQL database, you may skip these steps. Both databases are not required.

For a list of supported PostgreSQL databases, see Supported NiFi Registry databases.

  1. Install Red Hat Package Manager (RPM) according to the requirements of your operating system: 
    yum install https://yum.postgresql.org/[***POSTGRESQL_VERSION***]/redhat/rhel-[***RHEL_VERSION***]-x86_64/[***REPOSITORY_PACKAGE_NAME***]

    You can replace the placeholders with the appropriate values for your specific use case:

    • [***POSTGRESQL_VERSION***]: Replace this with the desired PostgreSQL version.
    • [***RHEL_VERSION***]: Replace this with the Red Hat Enterprise Linux (RHEL) version you are using.
    • [***REPOSITORY_PACKAGE_NAME***]: Replace this with the name of the repository configuration package for the specific PostgreSQL version and RHEL version you are targeting.
    For example, if you want to add the PostgreSQL 12 repository to a RHEL 8 system, you would use:
    yum install https://yum.postgresql.org/12/redhat/rhel-8-x86_64/pgdg-redhat12-12-4.noarch.rpm
  2. Install Postgres version 9.x or 10.x: 
    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
  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

Once you have installed PostgreSQL, configure the database for use with NiFi Registry.