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 thread.
View all comments
13 points
*

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.

permalink
report
reply
4 points

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

permalink
report
parent
reply
1 point

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

permalink
report
parent
reply
3 points

Seriously? Dammit

permalink
report
parent
reply
4 points

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

permalink
report
parent
reply
3 points

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.

permalink
report
parent
reply

Programmer Humor

!programmer_humor@programming.dev

Create post

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

  • Keep content in english
  • No advertisements
  • Posts must be related to programming or programmer topics

Community stats

  • 3.3K

    Monthly active users

  • 1.1K

    Posts

  • 39K

    Comments