I donât think Postgres shouldnât be just left as :latest or anything. At least the way I handle it, DB upgrades require manual intervention.
Comment on đ FairScan > Syncthing > Paperlees-ngx
MonkeMischief@lemmy.today â¨23⊠â¨hours⊠ago
Heads up if your Paperless is installed via Docker: be VERY CAREFUL about your database version and do an export often!
Mine has been down for a while because I did a pull and it doesnât support my version of Postgresql anymore. So itâs kinda a huge mess trying to figure out how to safely migrate it in the container.
I havenât been able to fix it yet so Iâve just left it disabled and gone without for a while. Itâs not fun.
Allegedly if you export from within Paperless, you can just start with a fresh updated database container and import when this happens. Oof.
aquovie@lemmy.cafe â¨20⊠â¨hours⊠ago
avidamoeba@lemmy.ca â¨14⊠â¨hours⊠ago
I just got burned by accidental latest tag on a pg container for Nextcloud. They moved some paths internally and it could no longer find the db.
Damage@feddit.it â¨22⊠â¨hours⊠ago
your version of postgres meaning that you use a db external to the docker container?
prenatal_confusion@feddit.org â¨22⊠â¨hours⊠ago
No sadly the upgrade path is a bit ducked. Their compose, their versions, still not working without intervention.
Damage@feddit.it â¨22⊠â¨hours⊠ago
Well, crap
MonkeMischief@lemmy.today â¨18⊠â¨hours⊠ago
Thank you, yes, exactly what I meant. Itâs a bit baffling such a mature project doesnât have some kind of migration script. :(
avidamoeba@lemmy.ca â¨16⊠â¨hours⊠ago
This is a reminder for self-hosters to put their apps (and their data) on snapshotting filesystems with automatic, regular snapahots turned on; and fix the app versions to at least the major version, across all containers.