this post was submitted on 19 Jul 2024
25 points (90.3% liked)

Lemmy

12541 readers
40 users here now

Everything about Lemmy; bugs, gripes, praises, and advocacy.

For discussion about the lemmy.ml instance, go to !meta@lemmy.ml.

founded 4 years ago
MODERATORS
nutomic@lemmy.ml
25
new easy way to update postgres in your docker-compose.yml (programming.dev)
submitted 3 months ago* (last edited 3 months ago) by Die4Ever@programming.dev to c/lemmy@lemmy.ml
3 comments fedilink hide all child comments
 

instead of

image: postgres:16-alpine

use

image: pgautoupgrade/pgautoupgrade:16-alpine

Then all the upgrade instructions of backup->update->import backups go away and all you need to do is restart the docker container. (still keep backups though!)

Reference: https://github.com/LemmyNet/lemmy/pull/4892/files

Since that pull request was merged, this will simplify future updates like 0.19.6 or 0.20.0

top 3 comments
sorted by: hot top controversial new old
[–] shnizmuffin@lemmy.inbutts.lol 14 points 3 months ago (1 children)

We just had a global IT meltdown because an update wasn't vetted properly and you have the audacity to suggest this for database infrastructure.

[–] exu@feditown.com 4 points 3 months ago

Since you're using specific tags over just latest, it will only ever upgrade the major version to what you set.

And it won't change the tags magically, so you can test all of it in your separate dev environment before running it in prod.

[–] sabreW4K3@lazysoci.al 1 points 3 months ago

Not a fan, but it's merged already, so meh.