We currently are using Atlas v 2.13.1 and Postgres v10 on Windows Server 2019 on our OMOP installation. It’s working fine, but we need to upgrade Postgres to v13 or higher due to vulnerability requirements in our Enterprise. I tried to follow the installation instructions precisely for Postgres, but I may have missed something or something may have changed, because some of the dialogs looked a bit different than they did in my instructions. After turning off Postgres v10 and turning on v17, I restarted Tomcat Catalina, and the Webapi application is not loading. I would attach my log here, but it will not let me do that. Can I get some assistance with this? I feel like I may need some direct assistance in a Teams or Zoom Meeting in order to work through the installation of Postgres. Does anyone have direct experience in upgrading Postgres to a supported version higher than 12?
Here is part of the log that may help:
Database: jdbc:postgresql://:5432/OHDSI (PostgreSQL 17.x)
Flyway:
Current version of schema “webapi”: 2.13.0…
Schema “webapi” is up to date.
WARN SQLState: 42501
ERROR: permission denied for table source
Application startup failed
…
nested exception is javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException:
could not extract ResultSet