Over the last week, I’ve been working on putting together a Postgres version of the Stack Overflow database, just like the SQL Server one that I’ve distributed for almost a decade now.
I’ve worked with Microsoft SQL Server for so long that I just kinda took backups for granted. We run a backup command, and SQL Server:
Logs activity to the transaction log while the backup is running Reads the exact contents of the database files, and writes them out to a backup file When it’s done, it also includes the transaction log changes so that it can use