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.
İirc they say dont do live backups as file copying but also docs say you could use filesystem snapshots
Seriously? Dammit
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.