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[***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
  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

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