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)

The hippo code is not compatible with having a SearchIndex defined in the source or backup workspace.xml.

The backup workspace.xml is also only generated during the first run. You may need to remove the SearchIndex tag from there after that.

Apart from that the, data transfer speed is quite low with that approach, we have 0,5MB/s.