Search Articles — Sudonull

Search Results

In this project

Open source PostgreSQL backups on Go

https://sudonull.com/open-source-postgresql-backups-on-go

Self-hosted tool for pg_dump with notifications, health checks and monitoring. Avoid data loss like in a real case with $1500/mo. Install on VPS or cloud in minutes.

Postgresus 2.0: PostgreSQL backup updates

https://sudonull.com/postgresus-2-0-postgresql-backup-updates

Postgresus 2.0: AES-256 encryption, RBAC, zstd compression, Helm for k8s. Automate PostgreSQL backups for teams. Learn new features for DBA and DevOps.

Databasus for backup of PostgreSQL and MySQL

https://sudonull.com/databasus-for-backup-of-postgresql-and-mysql

Deploy Databasus for automated backup of PostgreSQL, MySQL, MongoDB. Docker, K8s, encryption, PITR, notifications. Installation and features guide.

PostgreSQL Recovery without 2.5 TB Backup

https://sudonull.com/postgresql-recovery-without-2-5-tb-backup

Real case of PostgreSQL cluster destruction from WAL deletion and SIGKILL. Recovery steps with ignore_system_indexes, crash_info and pg_dump patches. Lessons for 1C DBA.

PostgreSQL: Transactions, Locks, Isolation Levels, MVCC, VACUUM

https://sudonull.com/postgresql-transactions-locks-isolation-levels-mvcc-vacuum

Deep dive into PostgreSQL transaction and locking mechanisms. Analysis of isolation levels (Read Committed, Repeatable Read, Serializable), MVCC, VACUUM, and methods for solving concurrency issues.

From the web

PostgreSQL: Documentation: 18: Chapter 25. Backup and Restore

https://www.postgresql.org/docs/current/backup.html

Learn how to back up and restore PostgreSQL databases using SQL dump, file system level backup, or continuous archiving. Compare the advantages and disadvantages of each approach and follow the examples and tips.

PostgreSQL backup and restore — Complete guide to backing up ...

https://dev.to/dmetrovich/postgresql-backup-and-restore-complete-guide-to-backing-up-and-restoring-databases-690

Jan 2, 2026 · PostgreSQL offers multiple backup approaches, each suited to different scenarios and requirements. This guide explores the complete backup and restore ecosystem for PostgreSQL , from simple logical backups to advanced point-in-time recovery strategies.

PostgreSQL: Documentation: 18: 25.1. SQL Dump

https://www.postgresql.org/docs/current/backup-dump.html

pg_dump is a regular PostgreSQL client application (albeit a particularly clever one). This means that you can perform this backup procedure from any remote host that has access to the database.

PostgreSQL Backup: The Complete Guide | SimpleBackups

https://simplebackups.com/learn/postgresql-backup

Everything you need to know about backing up PostgreSQL: pg _dump, pg_basebackup , WAL archiving, off-site storage and restores. Honest guides from the team that backs up Postgres every day.

PostgreSQL backup | Databasus

https://databasus.com/

Free and open source tool for PostgreSQL scheduled backups (with MySQL and MongoDB support). Save them locally and to clouds. Notifications to Slack, Discord, Telegram, email, webhook, etc.

pgBackRest - Reliable PostgreSQL Backup & Restore

https://pgbackrest.org/

Oct 17, 2026 · pgBackRest is a reliable backup and restore solution for PostgreSQL that seamlessly scales up to the largest databases and workloads.

PostgreSQL Backup - pg_dump & pg_dumpall - neon.com

https://neon.com/postgresql/administration/backup-database

Jun 19, 2026 · This tutorial shows you how to use PostgreSQL backup tools including pg _dump and pg_dumpall to backup databases in PostgreSQL.

Trending Now