“Official” documentation is not written on the topic.
“Unofficial” documentation can thou easily be found from many users of Gitea starting out with SQLite and migrating their DB to PostgreSQL. duckduckgo.com/?q=gitea+SQLite+to+POstgreSQL
Found this one, I will try out later. (I’ve had this same task on my own to-do for a while)