Cloud Platform Overview

Deploy PostgreSQL databases to the cloud with one command.

Architecture

┌─────────────────────────────────────────────────────────────┐
│                    Postbase Cloud                            │
├─────────────────────────────────────────────────────────────┤
│                                                              │
│   ┌─────────────┐           ┌─────────────────────────────┐│
│   │    CLI      │──────────▶│       Cloud API             ││
│   │             │           │  api.postbase.sh            ││
│   └─────────────┘           │                             ││
│                             │  • GitHub OAuth             ││
│                             │  • Project Management       ││
│                             │  • Database Provisioning    ││
│                             └──────────┬──────────────────┘│
│                                        │                    │
│                    ┌───────────────────┼───────────────────┐│
│                    │                   │                   ││
│            ┌───────▼───────┐   ┌───────▼───────┐   ┌──────▼──────┐│
│            │   Railway     │   │  Cloudflare   │   │  Cloudflare  ││
│            │  PostgreSQL   │   │     D1        │   │     R2       ││
│            │               │   │  (Metadata)   │   │  (Backups)   ││
│            └───────────────┘   └───────────────┘   └──────────────┘│
│                    │                                        │
│            ┌───────▼───────┐                                │
│            │Backup Service │                                │
│            │  (Railway)    │                                │
│            └───────────────┘                                │
│                                                              │
└─────────────────────────────────────────────────────────────┘

Features

One-Command Provisioning

# Login with GitHub
postbase cloud login
 
# Provision a database
postbase cloud provision production
 
# Done! Get connection string
postbase cloud url production

Enterprise PostgreSQL

Databases run on Railway with the Supabase PostgreSQL image:

Feature	Description
PostgreSQL 15	Latest stable version
pg_cron	Scheduled jobs
pgvector	Vector embeddings
PostGIS	Geospatial data
pgcrypto	Encryption
50+ extensions	Pre-installed

Automated Backups

Daily backups at 3 AM UTC
7-day retention (expandable)
Point-in-Time Recovery (PITR)
Zero egress fees with Cloudflare R2

Infrastructure Configuration

postbase cloud provision production \
  --region us-west-1 \
  --cpu 2 \
  --memory 4096 \
  --storage 50

Pricing

Free Tier

Resource	Limit
Databases	1
Storage	1 GB
Backups	3-day retention
PITR	Not included

Pro Tier ($20/mo)

Resource	Limit
Databases	Unlimited
Storage	100 GB
Backups	30-day retention
PITR	Included

Getting Started

1. Login

postbase cloud login

This opens your browser for GitHub authentication.

2. Create a Project

postbase cloud projects create myapp

3. Provision Database

# Staging environment
postbase cloud provision staging
 
# Production environment
postbase cloud provision production

4. Get Connection String

postbase cloud url production

5. Enable Backups

# Automated backups are enabled by default
 
# Enable PITR for point-in-time recovery
postbase cloud pitr enable -d production

Project Structure

myapp/                    # Your project
├── postbase.toml         # Configuration
├── migrations/           # Database migrations
├── .env                  # Environment variables
└── .env.production       # Production credentials

postbase.toml

[project]
name = "myapp"
 
[environments.staging]
provider = "railway"
connection_string = "${STAGING_DATABASE_URL}"
 
[environments.production]
provider = "railway"
connection_string = "${PRODUCTION_DATABASE_URL}"

Security

Secure Passwords

All cloud databases use auto-generated 32-character passwords:

YfF6Yfeqaf66IHSGLzhPcIAQ5Bs3Ayxa

Network Security

Private networking within Railway
SSL/TLS optional (disabled by default for Railway proxy)
IP allowlisting available

Credential Storage

Local credentials stored in:

~/.postbase/cloud.json

Never committed to version control.

Supported Regions

Region	Location
us-west1	Oregon, USA
us-east1	Virginia, USA
eu-west1	Ireland
ap-southeast1	Singapore

Next Steps

Authentication - GitHub OAuth setup
Projects - Project management
Provisioning - Database deployment
Configuration - Infrastructure options