Post B0ysN2JcbTDcpB4FyC by xchange@chaos.social
 (DIR) More posts by xchange@chaos.social
 (DIR) Post #B0yr9Z7niqaEZYYFRA by G33KatWork@infosec.exchange
       0 likes, 2 repeats
       
       Bah! A postgresql docker contain can only be upgraded to a newer major version by dumping the old database, wiping it, initializing it from a new version and then importing the dump again? Are you serious?
       
 (DIR) Post #B0yrFrTaPBjzE3k9XU by EinsTux@chaos.social
       0 likes, 0 repeats
       
       @G33KatWork s/docker container// that would be also the case for a plain normal installation. There is no magic for converting the binary database files to a newer release.
       
 (DIR) Post #B0yrJrGN8iWnitT6NE by G33KatWork@infosec.exchange
       0 likes, 2 repeats
       
       @EinsTux I could swear I head containers in the past that migrated easily to newer versions. inb4: They did the dump, reinit and import automatically.
       
 (DIR) Post #B0ysN2JcbTDcpB4FyC by xchange@chaos.social
       0 likes, 0 repeats
       
       @G33KatWork @EinsTux maybe try https://github.com/tianon/docker-postgres-upgrade
       
 (DIR) Post #B0yuz2qXHHW3NpiMjI by xchange@chaos.social
       0 likes, 0 repeats
       
       @G33KatWork @EinsTux see also https://www.postgresql.org/docs/18/pgupgrade.html  and https://blog.bitexpert.de/blog/postgresql_upgrade_with_docker and https://www.yugabyte.com/blog/postgresql-upgrade-framework/
       
 (DIR) Post #B0yuz3Uwr1qHPAcdii by G33KatWork@infosec.exchange
       0 likes, 2 repeats
       
       @xchange @EinsTux I just did it manually with 3000 backups inbetween. Annoying but if that Inventree database with all my parts is gone, I'll be crying for a week.
       
 (DIR) Post #B0yw4NNqRqHITrOu92 by xchange@chaos.social
       0 likes, 0 repeats
       
       @G33KatWork @EinsTux but if you do daily backups :^) you could just restore it into the new postgres version right?
       
 (DIR) Post #B0yw8OeRg0VZZS5B5c by G33KatWork@infosec.exchange
       0 likes, 2 repeats
       
       @xchange @EinsTux Yeah, Inventree itself does backups every now and then. That saved my ass already once.