Forgejo uses SQLite not Postgres.

I'd like to say this is because I thought it would be better to have backups that are consistent with both the database and the git repos inside them... but no, it's just that I set up Forgejo before I set up the Postgres server, and it is not possible to migrate.

Trust me. I tried. It appeared to work until it blew up whenever I tried to create a repo.

Also, fwiw: don't even bother with the forgejo dump command. It generates backups that seem sensible, but there isn't any way to actually restore them as they have SQL that's completely in the wrong order.