Hi @chidi
Welcome to ODK Forum, if you have a moment, feel free to introduce yourself here
Can you please share the details of your setup. What is the version of your postgresql? are you using database configured using docker-compose or some cloud hosted postgresql like RDS?
Also please share what was the last working version of Central, were you on v1.0.5 before upgrading? Did you follow this doc: https://docs.getodk.org/central-upgrade/? Some version upgrade requires special steps.