/postgresql

postgresql

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

mysql mongodb supabase postgresql storage digitalocean git redis server

The Ultimate PostgreSQL Database Backup Guide

June 9, 2021

A working PostgreSQL backup script, from pg_dump to an S3 upload and a cron schedule, plus the three gaps a shell script leaves open however well you write it.

Docker Postgres Backup/Restore Guide (with examples)

February 18, 2021

Learn how to back up and restore docker postgres databases, with plenty of examples and commands. Dump docker PostgreSQL db with ease and restore it.

PostgreSQL pg_dump & pg_restore Guide

December 1, 2020

Extensive guide about pg_dump and pg_restore commands, how to use them to back up and restore postgresql databases (pg_dump + pg_restore examples), common pg_dump options and what they do, and common errors.

How to restore a PostgreSQL backup

October 23, 2020

How to restore a PostgreSQL backup with psql or pg_restore, which one your dump file needs, and how to fix the errors that stop a restore part-way through.