How to upgrade self-hosted project

[hamanuha]

Improve documentation

Link

https://supabase.com/docs/guides/self-hosting/docker

Describe the problem

It's not quite clear how to update/upgrade the postgres image to the newest version when doing self-hosting with docker. Of course you can just change the used image in the compose file, but what has to be done apart from that? What about the migrations in the migrations/db/migrations folder. Shouldn't these be run on every start of the container? So that new migrations are run on the current database. It seems that the init scripts and migrations are only run on the first creation of the container if there is no data yet.

Describe the improvement

A guide that describes how to update/upgrade your self hosted Supabase postgres instance.