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.

[ejscheepers]

I am also interested in this👍🏼

[mschinis]

also interested 👍

[DDushkin]

Also interested

[k3vg3n]

Also interested!

[shan-developer]

Also interested

[benjaminschreck]

Coolify has an update button on its self hosted version. Something like this would be perfekt

[htetlynnhtun]

This kind of thing should be properly documented.

[vincentfretin]

I shared my own experience upgrading my self-hosted instance here https://github.com/supabase/supabase/issues/30834#issuecomment-2513954613 that works well if you don't have much data obviously.

[3DPrinterArt]

Also interested