Guides

Backup PostgreSQL

Archive PostgreSQL databases with ColdPlane.

This guide covers archiving PostgreSQL databases to cold storage using ColdPlane.

Prerequisites

PostgreSQL 9.6 or later
A user with SELECT permission on target tables
ColdPlane CLI installed

Create the Backup

coldplane backup create \
  --db-url "postgres://readonly:password@db.example.com:5432/production" \
  --tables "users,orders,products"

Both postgres:// and pg:// connection schemes are supported.

Verify the Backup

coldplane backup list
coldplane backup describe <backup-id>

Tuning Performance

For large tables, you can adjust the chunk size and number of parallel workers:

coldplane backup create \
  --db-url "postgres://readonly:password@db.example.com:5432/production" \
  --tables "events,logs" \
  --chunk-size 5000000 \
  --workers 8

Use a read replica connection string for production databases to avoid impacting query performance.

Guides

Step-by-step guides for common ColdPlane tasks.

Backup MySQL

Archive MySQL databases with ColdPlane.

On this page

Prerequisites Create the Backup Verify the Backup Tuning Performance