OpenHAB 4.0 Migration and JDBC PostgreSQL Integration

After successfully migrating my OpenHAB system from version 3.4.4 to 4.0.3, I encountered an intriguing challenge with the JDBC PostgreSQL persistence service. Despite restoring all data from the old system, the JDBC connector couldn’t locate the existing tables for certain items, resulting in errors like ‘unable to find table for item with name: ‘v_TE_Hygrometer_Temperatur’’. This was puzzling because the tables definitely existed in the database.

I tried various configurations, including renaming tables to match item names exactly and adjusting suffixes and case sensitivity. However, the issue persisted. The JDBC connector could access the database and store new data, creating new tables for active items, but it couldn’t recognize the restored ones.

I’m curious if others have faced similar issues during migrations and if there are specific steps or configurations that could resolve this. Any insights or troubleshooting tips would be greatly appreciated!

Platform Information:

  • Hardware: Raspberry Pi 4 4GB
  • OS: OpenHABian
  • Java Runtime Environment: Default for OpenHAB 4.0.3
  • openHAB Version: 4.0.3