For my own setups I try to stick to one database system (postgres, but I still have one Marinade too) and give all service their own database container via my docker compose.

Upgrading small databases (small as in “just a couple gigs”) for private use I found it most manageable to just dump and restore manually. That’s also my backup process, so I don’t use something completely different for a similar task.