💰 Cloud PostgreSQL: When It Makes Sense (and When It Doesn't)

As a solo dev, every dollar matters. Let's do the math that AWS doesn't want you to see.

The Sales Pitch vs Reality:
AWS says: "Managed PostgreSQL from $15/month!"

Reality check:

AWS RDS db.t3.micro (20GB):      $15/month
+ EBS storage (100GB):           $10/month
+ Backup storage (100GB):        $10/month
+ Read replica (optional):       $15/month
+ Multi-AZ (optional):           $30/month
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
Actual cost:                     $80/month

Self-hosted on $20 VPS:

Hetzner CPX21 (3vCPU, 4GB):     $20/month
+ Backups:                       $0 (included)
+ PostgreSQL:                    $0 (open source)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
Total:                           $20/month
Annual savings:                  $720/year

🎯 When to Use RDS (Solo Dev Edition):
✅ Use RDS when:


You're making $10K+/month (time > money)
You're AWS-heavy already (EC2, Lambda, etc.)
You need point-in-time recovery without ops work
Client requires "managed service" for compliance

❌ Skip RDS when:


You're pre-revenue or bootstrapping
You're comfortable with SSH and basic Linux
You want to learn PostgreSQL deeply
You have < 1M rows (self-hosting is easy)

💡 The Hybrid Approach (Best for Most):
Development: Local Docker
Staging: $5 VPS with backups
Production: Managed service when revenue > $5K/month

Real Solo Dev Scenarios:
Scenario 1: SaaS MVP


Users: < 1,000
Data: < 10GB
Traffic: < 100 req/min
→ Use $20 VPS with automated backups
Monthly cost: $20 vs $80 (save $720/year)

Scenario 2: API Service


Users: 5,000-10,000
Data: 50-100GB
Traffic: 1,000 req/min
→ Still self-hosted, upgrade to $40 VPS
Monthly cost: $40 vs $200 (save $1,920/year)

Scenario 3: Growing Startup


Users: 50,000+
Data: 500GB+
Traffic: 10,000 req/min
→ NOW consider managed (RDS/Aurora)
Time saved > money spent

🛠️ The $20 Production Setup:

# On Hetzner/DigitalOcean/Vultr
# 1. Install PostgreSQL 16
apt install postgresql-16

# 2. Configure automated backups
cat > /etc/cron.daily/pg-backup << 'EOF'
#!/bin/bash
pg_dump -U postgres mydb | gzip > /backup/mydb_$(date +%Y%m%d).sql.gz
# Upload to S3/Backblaze
rclone sync /backup remote:backups
# Keep last 30 days
find /backup -name "*.sql.gz" -mtime +30 -delete
EOF

# 3. Set up monitoring
apt install prometheus-postgres-exporter

# Done! Production-ready for $20/month

📊 3-Year Total Cost Comparison:



Setup
Year 1
Year 2
Year 3
Total




Self-hosted
$240
$480
$720
$1,440


RDS Basic
$960
$1,920
$2,880
$5,760


RDS + HA
$1,920
$3,840
$5,760
$11,520



Savings over 3 years: $4,320 - $10,080

🚀 When You SHOULD Migrate to Managed:
Signals it's time to pay for managed:


✅ Revenue > $10K/month
✅ More than 2 hours/month on DB ops
✅ Team > 1 person
✅ Customer SLAs requiring 99.9% uptime
✅ Multi-region needs

Rule of thumb: When DB downtime costs more than $80/hour, use managed.

Tomorrow's Preview:
Wednesday's premium masterclass: "Ship Your SaaS with PostgreSQL" - Complete production setup, authentication, multi-tenancy, and billing. Everything you need to launch.

Question: Are you self-hosting or using managed? What's your monthly DB cost?

#PostgreSQL #CloudComputing #SoloDev #CostOptimization #Bootstrapping

@postgres