Configuring NiFi Registry Metadata Stores in PostgreSQL

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

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

Download the Postgres JDBC driver and place it somewhere accessible to NiFi Registry:
```
/path/to/drivers/postgresql-42.2.2.jar
```
Create a database inside Postgres:
```
createdb nifireg
```

Create a database user and grant privileges:

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

After NiFi Registry service is installed, configure the database properties in Cloudera Manager:
- NiFi Registry JDBC Url (nifi.registry.db.url) – jdbc:postgresql://<POSTGRES-HOSTNAME>/nifireg
- NiFi Registry JDBC Driver (nifi.registry.db.driver.class) – org.postgresql.Driver
- NiFi Registry H2 directory storage location (nifi.registry.db.driver.directory) – /path/to/drivers
  note
  
  The NiFi Registry H2 directory storage location field specifies the NiFi Registry database driver directory. The H2 database is used by default. Update this field when you are configuring it for an external database.
- NiFi Registry Database Username (nifi.registry.db.username) – nifireg
- NiFi Registry Database Password (nifi.registry.db.password) – changeme

When you have completed the NiFi Registry database configuration, move on to installing Cloudera Manager and your CDP Private Cloud Base.