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.
İ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.
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.Seriously? Dammit