Re: [keycloak-user] DB from MongoDB to PostgreSQL migration, how?

I have exported Keycloak Mongo db from 1.9.8 and successfully imported to H2 db in the same 1.9.8 Keycloak version. Then I have tried to export it back again and import with PostgreSQL, but it failed at: 13:44:33,341 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (ServerService Thread Pool -- 47) SQL Error: 0, SQLState: 42703 13:44:33,342 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (ServerService Thread Pool -- 47) ERROR: column realmentit0_.certificate does not exist Position: 563 Also I have copied H2 db files (keycloak.h2.db keycloak.trace.db keycloak.trace.db.old) to the 2.0.0, but unfortunately it won't start: 14:19:17,717 INFO [org.hibernate.dialect.Dialect] (ServerService Thread Pool -- 46) HHH000400: Using dialect: org.hibernate.dialect.H2Dialect 14:19:17,732 WARN [org.hibernate.dialect.H2Dialect] (ServerService Thread Pool -- 46) HHH000431: Unable to determine H2 database version, certain features may not work 14:19:17,799 INFO [org.hibernate.envers.boot.internal.EnversServiceImpl] (ServerService Thread Pool -- 46) Envers integration enabled? : true 14:19:18,900 INFO [org.hibernate.validator.internal.util.Version] (ServerService Thread Pool -- 46) HV000001: Hibernate Validator 5.2.3.Final 14:19:20,370 INFO [org.hibernate.hql.internal.QueryTranslatorFactoryInitiator] (ServerService Thread Pool -- 46) HHH000397: Using ASTQueryTranslatorFactory 14:19:24,582 ERROR [org.keycloak.services] (ServerService Thread Pool -- 46) KC-SERVICES0002: Failed to migrate datamodel: java.lang.NullPointerException On 01/08/17 17:17, Bill Burke wrote: -- skype. kamil.kapturkiewicz tel/signal. +44 758 306 8467