Database Backups Without the Bloat

Logosofia no Dia a Dia · Apr 27, 2026 · 23m

Most database backup tools have been free and open-source for decades — but the expertise to use them wasn’t. This episode breaks down the actual CLI tools for Postgres, SQLite, and SQL Server backups: pg_dump vs pg_basebackup, the role of WAL archiving, native incremental backups in Postgres 17, and why AI coding agents are making DBA-level backup strategies accessible to anyone. We cover Docker-hosted databases, retention policies, and when to reach for pgBackRest, WAL-G, or just a simple sqlite3 command. If you’ve been wondering whether you really need a commercial backup tool for your CRM…