Getting Started
- Architecture
  - Backup Lifecycle & data flow
  - Backup workers
  - Our infrastructure
  - Connecting your worker/server
- Features
  - Scheduling
  - Retention
  - Notifications
  - Incremental Backups
  - Backup Automation
  - Backup Webhook
  - Backup Trigger URL
  - Teams, Projects & users
  - Backup storage
  - Backup Custom Scripts
  - Backup Anomaly Detection
- Security & Privacy
  - Backup Encryption
  - How your data is processed
  - Uninstalling
  - How can I restrict/limit the permissions provided to SimpleBackups?
  - Data Processing Agreement
- Account & Billing
  - Trial plan
  - Free plan
  - Subscriptions
  - How to cancel my account?
  - Manage invoices and payment receipts
  - My payment failed, what should I do?
  - How to redeem a coupon?
  - How can I give access to my accountant?
  - How to grant owner access to another user?
Database Backup
- MySQL Backup
  - Restore a MySQL backup
  - Guides
  - How to dump stored procedures / functions
  - How to Enable Binary Log for MySQL or MariaDB
  - How to create a Passwordless MySQL Backup
  - FAQ
  - Hot Backups in MySQL Using Percona XtraBackup
  - Restore PlanetScale / Vitess MySQL Backups
- PostgreSQL Backup
  - Restore a PostgreSQL backup
  - Guides
  - FAQ
- MongoDB Backup
  - Restore a MongoDB backup
  - MongoDB Backup and User Roles
  - Restore MongoDB Atlas Collection using MongoDB Compass
  - Guides
  - Backup From a Read-Replica Node
- Redis Backup
  - Restore a Redis backup
- DBaaS Providers
  - How to create serverless backups for managed databases?
  - DigitalOcean Managed Redis
  - DigitalOcean Managed MySQL
  - DigitalOcean Managed PostgreSQL
  - DigitalOcean Managed MongoDB
  - DigitalOcean Managed database backup
  - Supabase PostgreSQL
  - Neon PostgreSQL
  - Aiven MySQL
  - Aiven PostgreSQL
  - Heroku PostgreSQL
  - Exoscale PostgreSQL
  - Vultr Database
  - OVH Database
  - Scaleway Database
  - Planetscale Database
  - Scalingo Database
  - Amazon RDS Database
  - Aiven Database
  - Scalingo Database
- Help & Tips
  - FAQ
  - Connecting a private database
Server & File Backup
- Create a file/server backup
- Restore a file/server backup
- Incremental File Backups
Storage Backup
- FAQ
- Guides
- Storage backup in a nutshell
- How to preserve S3 or DigitalOcean Spaces metadata on the files/objects
Server & Volume Snapshot
- Providers
  - Amazon Lightsail
  - AWS EC2
  - DigitalOcean
  - Exoscale
  - Hetzner
  - Linode
  - Scaleway
  - UpCloud
  - Vultr
  - OVH
  - Neon
  - Scalingo
  - Planetscale
  - Amazon RDS
  - Aiven
- Resources
  - Restore a Snapshot
  - FAQ
SaaS App Backup
- Apps
  - Knack
  - GitHub
  - Gitea
  - Gitlab
  - Notion
- Resources
  - FAQ
Storage Providers
- AWS S3
- Amazon S3 Glacier
- Azure Blob
- Alibaba Cloud
- Backblaze B2
- Synology C2
- CloudFlare R2
- DigitalOcean Spaces
- Dropbox
- Exoscale
- Egnyte
- Filebase
- Google Cloud Storage
- Google Cloud Storage (S3-compatible credentials)
- Google Drive
- Hetzner Storage Box
- IDrive e2
- Leviia
- MinIO
- NAS or local volume
- SFTP Storage
- SimpleStorage
- Storadera
- Storj
- UpCloud
- Wasabi
- Supabase
- IONOS
- CEPH
Help, Tips & Troubleshooting
- Connecting a Server
  - SimpleBackups IP addresses (firewall)
  - Automatically provision servers
  - Errors & Troubleshooting
- Storing your backups
  - Errors & Troubleshooting
  - How to customize the backup storage path
  - Backup Storage FAQ
  - Connecting read-only storage bucket
  - Google Cloud Storage Updated
- Backups & Logs
  - How to download individual files when backing up all databases?
  - How to generate an RSA PEM (asymmetric) key pair?
- Backup Settings & Options
  - Custom backup schedule via cron
- Others
  - curl 35 ssl error
  - The displayed Storage Usage seems incorrect, what should I do?
  - Can I connect multiple "Cloud Providers" within the same account?
  - Solving Error 2013: Lost connection to MySQL server during query when dumping table
  - Backups failing for MySQL server versions (5.7.41 and 8.0.32)
  - PostgreSQL Backup Privileges Issues
  - pg_dump: error: Error message from server: SSL SYSCALL error: EOF detected
  - mysqldump: Couldn’t execute ‘show create table table_name‘
  - Using Tailscale with Docker for Secure Database Backups
More

Guides

Guides & how to backup your PostgreSQL database

Find all our PostgreSQL guides and “how to” on our blog:

Find out about PostgreSQL in our blog! New releases, guides and how-tos to help you manage your server, database, storage and application backups.

https://simplebackups.com/blog/using-simplebackups/postgresql

Did this answer your question?

😞

😐

🤩

Last updated on August 4, 2021

Restore a PostgreSQL backup FAQ