Hi,
I’m using Postgres with Gitea and have two DB credentials:
- “gitea_admin” - All privileges except superuser
- “gitea_user” - All privileges except superuser and create databases
All tables have owner set to “gitea_admin”
During migration and upgrades, I use the “gitea_admin” credentials in Gitea’s app.ini. This works fine and has allowed me to migrate from a v1.12 to v.1.21 without issue.
For normal operation, I normally use the “gitea_user” credentials. Since v1.14, I receive the error “pq: must be owner of table session during ensure up to date” and Gitea fails to run.
I believe it’s part of the migration preflight run at startup. The database is already upgraded to the correct version, so does Gitea really require the table owner credentials for day to day operations?
Thanks in advance!