# Issues after migrating PostgreSQL from 11.5 to 16

**URL:** <https://community.bloomreach.com/t/issues-after-migrating-postgresql-from-11-5-to-16/4809>\
**Category:** Experience Manager (PaaS/OnPrem)\
**Created:** [August 29, 2025, 11:29am UTC](https://community.bloomreach.com/t/issues-after-migrating-postgresql-from-11-5-to-16/4809 "2025-08-29T11:29:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![B\_A](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.bloomreach.com/b_a/32/1693_2.png) [@B\_A](https://community.bloomreach.com/u/B_A)\
**Post date:** [August 29, 2025, 11:29am UTC](https://community.bloomreach.com/t/issues-after-migrating-postgresql-from-11-5-to-16/4809/1 "2025-08-29T11:29:13Z")

</div>

![Снимок экрана 2025-08-26 в 09.52.44](https://canada1.discourse-cdn.com/flex027/uploads/bloomreach1/original/2X/7/723292ac76483f0f25d828ec98ed9ae44e6fb0f4.jpeg)

Hello,

I encountered a problem after migrating the PostgreSQL database to a new server and would like to clarify the correct sequence of steps.

What I did:

\* On the old server, PostgreSQL version 11.5 was used, while on the new server version 16 was installed.

\* In `Repository.xml`, I simply changed the database `url` to the new one, without shutting down the current site instance.

\* Then I performed a \*redeploy\* and launched the site with the new database.

\*\*After this, I started receiving frequent errors.\*\*

For example, when working with documents (unpublish), the following error occurs:

```auto
org.onehippo.repository.api.WorkflowException: 

```

```auto
org.apache.jackrabbit.core.state.ItemStateException: 

```

```auto
Unable to resolve path for item: 85bf1d53-ba9b-455d-9f66-87360b683451/{http://www.jcp.org/jcr/1.0}successors

```

I would like to ask you:

1. In what cases do such errors typically occur when working with Bloomreach CMS?

2. Which steps did I perform incorrectly during the database migration?

3. What should be the correct sequence of actions when upgrading the repository from PostgreSQL 11.5 to PostgreSQL 16?

I would greatly appreciate any recommendations or best practices.

Thank you  
**If additional information is needed, I am ready to provide it in this thread. Please help me** ❤ 🫠

---

<div class="post-metadata">

**Author:** ![machak](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.bloomreach.com/machak/32/1298_2.png) [@machak](https://community.bloomreach.com/u/machak)\
**Post date:** [August 29, 2025, 3:46pm UTC](https://community.bloomreach.com/t/issues-after-migrating-postgresql-from-11-5-to-16/4809/2 "2025-08-29T15:46:38Z")

</div>

duplicate of [Publish/Unpublish Error](https://community.bloomreach.com/t/publish-unpublish-error/4807)

Have you tried to perform re-indexing as suggested in above thread?

If re-indexing doesn’t help, you might need to upgrade DB via migration, see:

> **[GitHub - woonsanko/recipe-for-hippo-db-migration: Recipe for Hippo CMS Database Migration](https://github.com/woonsanko/recipe-for-hippo-db-migration)**
>
> Recipe for Hippo CMS Database Migration

(above setups are mostly used to transfer data between different databases but can also be used for same database in case upgrades to different versions)

---

<div class="post-metadata">

**Author:** ![Anuarius23](https://avatars.discourse-cdn.com/v4/letter/a/85f322/32.png) [@Anuarius23](https://community.bloomreach.com/u/Anuarius23)\
**Post date:** [September 3, 2025, 4:14pm UTC](https://community.bloomreach.com/t/issues-after-migrating-postgresql-from-11-5-to-16/4809/3 "2025-09-03T16:14:02Z")

</div>

I’ve encountered a similar issue after migrating the database. When I try to search for a document via the console, it doesn’t show up, even though the content is visible in the admin panel. As a workaround, I create a copy of the document, but it’s not very convenient. Also, the CMS has become noticeably slower.

I’m also curious about the conditions under which this happens, and where the keys are stored. For instance, I can find documents using their UUIDs (which seem to work fine), but I can’t locate them in the PostgreSQL database.