580
10 things that block your Happiness
(programming.dev)
Transcript:
10 things that block your Happiness
- Self-hatred
- Not being able to let go of the past.
- Not being able to forgive yourself.
- Not being able to value who you are.
- Assuming RAID is backup.
- Not making backups.
- Not verifying backups and finding out restore time.
- Needing other people to validate you.
- Letting other people define who you are.
- Trying to be perfect and to please everyone.
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.
Yikes! Thanks for the tip. I'm just starting to learn about Postgres. Think I'll stick with MySQL or SQLite for now... :o
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.İirc they say dont do live backups as file copying but also docs say you could use filesystem snapshots
Yeah. I knew better, but it just didn't occur to me until I was confirming my backups later.
Seriously? Dammit