SimpleBackups
/postgresql

postgresql

News, tips, guides and tools by the creators of SimpleBackups web

pgBackRest: how to back up, restore and recover PostgreSQL

Latest Post

pgBackRest: how to back up, restore and recover PostgreSQL

August 13, 2026

How to set up pgBackRest for PostgreSQL: install, stanza config, full and incremental backups, restore, point-in-time recovery and S3 repositories.

Read more →

Best Alternatives to a pg_dump + Cron Script for PostgreSQL Backups

Best Alternatives to a pg_dump + Cron Script for PostgreSQL Backups

July 6, 2026

Replacing pg_dump + cron? SimpleBackups automates PostgreSQL backup scheduling, alerting, and restore verification. Zero overhead. Compare your options.

How to Analyze PostgreSQL Table Size

How to Analyze PostgreSQL Table Size

November 8, 2024

Find which PostgreSQL tables are using your disk: one query over pg_stat_user_tables that ranks every table by total size, indexes and related data included.

PostgreSQL Backup: Custom vs Plain Export

PostgreSQL Backup: Custom vs Plain Export

November 1, 2024

PostgreSQL custom format versus plain export, what each one costs you at restore time, and how to pick between them before you take the backup rather than after.

The Ultimate Aiven Data Pipeline Backup Guide

The Ultimate Aiven Data Pipeline Backup Guide

March 29, 2024

Automate backups of the PostgreSQL database in your Aiven data pipeline: grab the connection string, whitelist the backup IPs, and store the dumps on S3.

How to create a Neon database backup

How to create a Neon database backup

March 20, 2024

Back up a Neon PostgreSQL database with SimpleBackups: create a backup user, take the connection string, allow network access, then schedule and restore it.

How to Backup Neon Database

How to Backup Neon Database

March 19, 2024

Back up a Neon PostgreSQL database with pg_dump: the connection string format, the exact commands to run, and how to schedule the dumps to off-site storage.

How to run PostgreSQL on Docker

How to run PostgreSQL on Docker

December 30, 2023

Run PostgreSQL on Docker with a single command or Compose, then persist the data with a named volume so removing the container does not delete your database.

Supabase backup & recovery guide - Video Tutorial

Supabase backup & recovery guide - Video Tutorial

December 29, 2023

Video tutorial: back up and restore a Supabase Postgres database, with a link to the full written guide when you need the detail behind each of the steps.

PostgreSQL vs. MongoDB - Video Comparison

PostgreSQL vs. MongoDB - Video Comparison

December 19, 2023

This video is your ultimate battle guide comparing Postgres and Mongo! We break down the pros, cons, and everything in between to help you pick the winner for your specific needs.