this post was submitted on 18 Dec 2024
570 points (99.3% liked)

Programmer Humor

19817 readers
89 users here now

Welcome to Programmer Humor!

This is a place where you can post jokes, memes, humor, etc. related to programming!

For sharing awful code theres also Programming Horror.

Rules

founded 2 years ago
MODERATORS
 

Source

Transcript:

10 things that block your Happiness

  1. Self-hatred
  2. Not being able to let go of the past.
  3. Not being able to forgive yourself.
  4. Not being able to value who you are.
  5. Assuming RAID is backup.
  6. Not making backups.
  7. Not verifying backups and finding out restore time.
  8. Needing other people to validate you.
  9. Letting other people define who you are.
  10. Trying to be perfect and to please everyone.
you are viewing a single comment's thread
view the rest of the comments
[–] MajorHavoc@programming.dev 14 points 4 days ago* (last edited 4 days ago) (3 children)

Pro tip: Copying a Postgres database while live transactions are interacting with it frequently results in a corrupt backup.

Thankfully I test my Luanti backups.

Edit: I should clarify - My dangerous backup method was a naive file copy. I'm sure there's a different correct way to do a live backup. I just haven't checked into it yet, since stopping my Luanti server for a backup is no big deal.

[–] alper_celik@lemmy.world 4 points 2 days ago (1 children)

İirc they say dont do live backups as file copying but also docs say you could use filesystem snapshots

[–] MajorHavoc@programming.dev 1 points 2 days ago

Yeah. I knew better, but it just didn't occur to me until I was confirming my backups later.

[–] Kojichan@lemmy.world 4 points 4 days ago (1 children)

Yikes! Thanks for the tip. I'm just starting to learn about Postgres. Think I'll stick with MySQL or SQLite for now... :o

[–] umbraroze@lemmy.world 3 points 2 days ago

Choosing to not use something is not a good way to learn how to use it.

In this particular instance, the lesson is to either a) use the provided database tools (e.g. pg_dumpall) for live backup, or b) bring the database cluster down before you backup the raw data folder.

[–] FrostyCaveman@lemm.ee 3 points 4 days ago

Seriously? Dammit