I’m currently struggling with upgrading some Postgres DBs on my home-k3s and I’m seriously considering throwing it all away since it’s such a hassle.

So, how do you handle DBs? K8s? Just a regular daemon?

  • bigredgiraffe@lemmy.worldEnglish
    1·
    1 year ago

    Are we talking database schema migrations or migrating a database between Postgres instances?

    If it’s the former, the pattern is usually to run them in init containers or Jobs but I have been wanting to try out SchemaHero for a while which is a tool to orchestrate it and looks pretty neat.

    ETA: Thought I was replying to your below comment but Memmy deleted it the first time for some reason, my bad.