SimpleBackups

guides

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

How to Analyze PostgreSQL Table Size

Latest Post

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.

Read more →

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.

What is Grandfather-Father-Son Backup Strategy?

What is Grandfather-Father-Son Backup Strategy?

September 13, 2024

Explore ins and outs of Grandfather-Father-Son backup strategy, its benefits (together with limitations), as well as practical implementations and real-life case studies.

What is the 3-2-1 backup strategy?

What is the 3-2-1 backup strategy?

September 12, 2024

The 3-2-1 rule: three copies of your data, on two kinds of media, with one of them off-site. Where it came from, how to apply it, and where it runs out.

GitHub vs Compliance: Why You Need Backups for ISO 27001 and SOC 2

GitHub vs Compliance: Why You Need Backups for ISO 27001 and SOC 2

August 15, 2024

Learn why relying solely on GitHub's built-in redundancy isn't enough for ISO 27001 and SOC 2 compliance. Discover the importance of independent backups to protect your code and meet stringent data protection standards.

The Ultimate Developer's Guide to GitHub Backups

The Ultimate Developer's Guide to GitHub Backups

August 6, 2024

How to back up GitHub repositories and metadata with code snippets for git mirror, the GitHub API, and GitHub Actions, plus backing up a whole organization to S3 and restoring from a backup.

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.

The Ultimate GitLab Backup Script

The Ultimate GitLab Backup Script

February 16, 2024

A Bash script that backs up GitLab repositories through the API: what you need from git, jq and an access token, and how to schedule the script to run.