Postgres

Postgres provides the option to use an externally located database that also supports high availability.

The following steps are required to use Postgres:

1. Download the Postgres JDBC driver and place it somewhere accessible to NiFi Registry

   
   /path/to/drivers/postgresql-42.2.2.jar
   

2. Create a database inside Postgres

   
   createdb nifireg
   

3. Create a database user and grant privileges

   
   psql nifireg
   CREATE USER nifireg WITH PASSWORD 'changeme';
   GRANT ALL PRIVILEGES ON DATABASE nifireg to nifireg;
   \q
   

4. Configure the database properties in nifi-registry.properties

   
   nifi.registry.db.url=jdbc:postgresql://<POSTGRES-HOSTNAME>/nifireg
   nifi.registry.db.driver.class=org.postgresql.Driver
   nifi.registry.db.driver.directory=/path/to/drivers
   nifi.registry.db.username=nifireg
   nifi.registry.db.password=changeme