I am running a self hosted temporal instance and trying to upgrade temporal app version from 1.22.4 to 1.26.2 and using helm chart to do so but while doing that i’m getting scheme compatibility issue.. Below is the log, i receive after running this command “temporal-sql-tool -ep “$PG_HOST” -p “$PG_PORT”
-u “$PG_USER” -pw “$PG_PASSWORD”
–pl postgres
–db temporal
update-schema -d
/etc/temporal/schema/postgresql/v12/visibility/versioned”
2025-04-10T16:56:45.875Z INFO UpdateSchemeTask started {"config":
2025-04-10T16:56:45.878Z DEBUG found zero updates from current version 1.7 {"logging-call-at": "updatetask.go:127"}
2025-04-10T16:56:45.878Z INFO UpdateSchemeTask done {"logging-call-at": "updatetask.go:120"}
Dependency is to first update the schema and do the upgrade but i find no updates, so how am i supposed to do the upgrade?
Any help on this is highly appreciated. Thank you!