H2SQL to Postgresql failing.

[Brian Whitney]

Hi all,

I'm currently trying to migrate H2 DB engine data to Postgresql 9.6, so that I can further upgrade to the latest Confluence. I followed this guide, https://confluence.atlassian.com/doc/migrating-to-another-database-148867.html

I've got a second instance of the same confluence version, (5.7.4) and am getting the following error when trying to restore from backup on the new instance..

Import failed. Check your server logs for more information. java.lang.RuntimeException: Could not get unique fields for table 'AO_187CCC_SIDEBAR_LINK'

I checked my logs, and not finding this error anywhere.  

My System:

Debian Stretch

Postgresql 9.6

Confluence 5.7.4

I hope I'm just doing something stupid, any insight is appreciated.

thanks,

Brian

[Brian Whitney · Accepted solution]

I was able to resolve this by replacing the Postgresql jdbc driver in /opt/atlassian/confluence/confluence/WEB-INF/lib/

I downloaded the proper jdbc driver from https://jdbc.postgresql.org/download.html

Replaced /opt/atlassian/confluence/confluence/WEB-INF/lib//postgresql-9.2-1002.jdb
c4.jar with the one from the link above. Restarted confluence, continued on with the restore which finished without error.  After some testing, I was able to upgrade to the latest Confluence without issue. 

thanks,

Brian