Hi Kevin - I set the below in nifi-registry.properties file to make the switch. Kept the H2 properties commented for reference as they came out of the box.
: : # legacy database properties, used to migrate data from original DB to new DB below # NOTE: Users upgrading from 0.1.0 should leave these populated, but new installs after 0.1.0 should leave these empty nifi.registry.db.directory=./database nifi.registry.db.url.append=;LOCK_TIMEOUT=25000;WRITE_DELAY=0;AUTO_SERVER=FALSE #nifi.registry.db.directory= #nifi.registry.db.url.append= # database properties #nifi.registry.db.url=jdbc:h2:./database/nifi-registry-primary;AUTOCOMMIT=OFF;DB_CLOSE_ON_EXIT=FALSE;LOCK_MODE=3;LOCK_TIMEOUT=25000;WRITE_DELAY=0;AUTO_SERVER=FALSE #nifi.registry.db.driver.class=org.h2.Driver #nifi.registry.db.driver.directory= #nifi.registry.db.username=nifireg #nifi.registry.db.password=nifireg #nifi.registry.db.maxConnections=5 #nifi.registry.db.sql.debug=false # added by Jagrut for postgres nifi.registry.db.url=jdbc:postgresql://localhost/nifiregistry nifi.registry.db.driver.class=org.postgresql.Driver nifi.registry.db.driver.directory=/Library/PostgreSQL/pgJDBC nifi.registry.db.username=postgres nifi.registry.db.password=postgres nifi.registry.db.maxConnections=5 nifi.registry.db.sql.debug=false : : Thanks. -- Jagrut On Sat, Jun 23, 2018 at 2:02 PM, Kevin Doran <[email protected]> wrote: > Hi Jagrut, > > I think this is configurable. How did you configure you > nifi-registry.properties file? > > Thanks, > Kevin > > ________________________________ > From: Jagrut Sharma <[email protected]> > Sent: Saturday, June 23, 2018 2:43:33 PM > To: [email protected] > Subject: Registry H2 to PostgreSQL migration > > Hi - I performed migration from H2 to PostgreSQL, and ran into a potential > bug. > > After switching the database config, registry started up fine. But the > tables were all empty. On digging a bit deeper, I found that the default H2 > database file is named nifi-registry-primary.mv.db. The migration code is > looking for a file named nifi-registry.mv.db and hence unable to find it. > The log reports 'Did not find legacy database file...' > > To verify this, I renamed existing H2 file to nifi-registry.mv.db. Upon > startup, the file was detected and migration happened properly. > > I can file a JIRA, but just wanted to make sure I was not missing any > config step. > > Thanks. > -- > Jagrut > -- Jagrut
