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.

You have installed the JDK. For details, see Installing the JDK.
  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/pgdg-redhat96-9.6-3.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.