This issue looks similar to Upgrade Zammad 6.0 to 6.1 failed
Extra information that was missing.
/opt/zammad/config/database.yml
production:
adapter: postgresql
database: zammad
pool: 50
timeout: 5000
encoding: utf8
username: zammad
password: xxxxx
Did anyone else had this issue upgrading to v6.3.1 please?