Database migration

Hi Community,
we are using Oracle DB and planning to migrate to PostgreSQL, is there any official documentation on bloomreach website for migration? we are on hippo 13, and I couldn’t find any documentation on that.

Thanks.

1 Like

You can follow these steps:

2 Likes

I’ve followed steps in the recipe-for-hippo-db-migration project for a MySQL to Postgres migration dry run just using the default v12 archetype but we’ve run into a exception. Any help or pointers would be helpful.

Exception in thread "main" java.lang.ClassCastException: org.apache.jackrabbit.core.state.SharedItemStateManager cannot be cast to org.hippoecm.repository.jackrabbit.HippoSharedItemStateManager
    at org.hippoecm.repository.FacetedNavigationEngineImpl.doInit(FacetedNavigationEngineImpl.java:655)
    at org.apache.jackrabbit.core.query.AbstractQueryHandler.init(AbstractQueryHandler.java:78)
    at org.apache.jackrabbit.core.config.RepositoryConfigurationParser$1.getQueryHandler(RepositoryConfigurationParser.java:683)
    at org.apache.jackrabbit.core.config.WorkspaceConfig.getQueryHandler(WorkspaceConfig.java:251)
    at org.apache.jackrabbit.core.SearchManager.<init>(SearchManager.java:171)
    at org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.getSearchManager(RepositoryImpl.java:1902)
    at org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.doPostInitialize(RepositoryImpl.java:2140)
    at org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.initialize(RepositoryImpl.java:2038)
    at org.apache.jackrabbit.core.RepositoryImpl.initStartupWorkspaces(RepositoryImpl.java:544)
    at org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:327)
    at org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:616)
    at org.apache.jackrabbit.core.RepositoryCopier.copy(RepositoryCopier.java:148)
    at org.apache.jackrabbit.core.RepositoryCopier.copy(RepositoryCopier.java:112)
    at org.apache.jackrabbit.standalone.Main.backup(Main.java:217)
    at org.apache.jackrabbit.standalone.Main.run(Main.java:160)
    at org.apache.jackrabbit.standalone.Main.main(Main.java:59)