From https://hackernoon.com/elephant-in-the-room-database-backup-574da50e6d88 For instance, mysqldump will take dumps conforming to the client’s character set, and your favorite emojis such as 🍣 and 🍺 in utf8mb4 could be corrupt and replaced by ? in the backup. If you have never checked, do it right now. Just set --default-character-set=binary option — you’re welcome. Or if you missed the --single-transaction option, you are likely to have inconsistent backups (e.g. item changed hands but money didn’t transfer) that are never easy to spot even if you regularly test the recovery procedure manually.
Showing posts from December, 2019
- Other Apps
Free training material (documentation) in French: https://public.dalibo.com/exports/formation/manuels/formations/ Free book: https://books.goalkicker.com/PostgreSQLBook Documentation about the internals of PostgreSQL: The internals of PostgreSQL Configuration wizards https://pgconfigurator.cybertec-postgresql.com/ https://pgtune.leopard.in.ua/ https://postgresqlco.nf / is a bit different, but can help https://pgmetrics.io/ Not a wizard, but provides many info about PG instance Troubleshooting Observability: what function gives information about which component/process? https://pgstats.dev/ https://postgresqlco.nf/ You can upload your configuration, get recommendations, etc Clients psql: PostgreSQL-provided client (command-line) pgcli CLI client with auto-completion and syntax highlighting https://www.pgcli.com/ "Full" list Toad for PostgreSQL Kangaroo https://dbkangaroo.github.io/ Backups barman https://sourceforge.net/projects/pgbarman/files/2