I have need to change to database used by Gitea from current MySQL to PostgreSQL.
I assumed this would be simple swapping of database configs and database migration but there seems to be some extra steps needed as after migration I can’t login to gitea anymore.
I shutdown gitea server, used pgloader to migrate mysql to postgresql database, updated gitea configuration to point to pg database and started gitea.
I get gitea frontpage but when I try to login with my AD account I get “Username or password is incorrect.”. If I switch database to point to old mysql instance the login works again.
So far I’ve re-added the AD settings with “gitea admin add” command but seems the database migration with default options won’t work. Adding “preserve index names” seems to be required option and logs seem to point that bigint -> bigserial change should be done as well.
Has anyone completed such a migration and has notes to share?