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.
  • MajorHavoc@programming.dev
    14·
    9 days ago

    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.

    • Kojichan@lemmy.world
      4·
      9 days ago

      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·
        8 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.