Operations

Managed Databases


PostgreSQL

Use your cloud provider's managed PostgreSQL service for automated backups, failover, and patching:

ProviderServiceMinimum Version
AWSRDS for PostgreSQL15+
GCPCloud SQL for PostgreSQL15+
AzureAzure Database for PostgreSQL Flexible Server15+

Configuration recommendations:

ParameterRecommendationRationale
Instance size2 vCPU / 8 GB RAM minimumWorkflow state queries are CPU-bound
Storage100 GB SSD (gp3 or equivalent)Journal and execution logs grow over time
max_connections200+Support PgBouncer pool + direct admin connections
shared_buffers25% of RAMStandard PostgreSQL tuning
High availabilityMulti-AZ / regionalAutomated failover for production
BackupsDaily automated, 7–30 day retentionPoint-in-time recovery

Connection string format:

1
DATABASE_URL="postgresql://orcher:PASSWORD@your-instance.region.rds.amazonaws.com:5432/orcher?sslmode=require"

Always enable SSL (sslmode=require or sslmode=verify-full) for managed database connections.

PgBouncer

For high-concurrency workloads (100+ concurrent workflows), deploy PgBouncer between the orchestrator and managed PostgreSQL. Some managed services include built-in connection pooling:

  • AWS RDS Proxy — Managed connection pooler for RDS
  • GCP Cloud SQL — Built-in connection pooling via Cloud SQL Auth Proxy
  • Azure — Built-in PgBouncer in Flexible Server (enable via server parameters)

If your provider doesn't include pooling, deploy PgBouncer as a sidecar container or separate service. See Docker deployment for PgBouncer configuration.

Redis

Optional but recommended for production. Wakes workers via LPUSH/BRPOP as soon as work is queued.

ProviderService
AWSElastiCache for Redis
GCPMemorystore for Redis
AzureAzure Cache for Redis

Configuration recommendations:

ParameterRecommendationRationale
Instance size1–2 GBDispatch queues are small; most data is in PostgreSQL
Version7.0+Required for full feature support
PersistenceAOF enabledSurvives restarts without losing pending dispatches
Cluster modeDisabledOrcher uses simple key operations, not sharded
High availabilityReplica with automatic failoverAvoid dispatch interruptions

Connection string format:

1
REDIS_URL="redis://your-instance.region.cache.amazonaws.com:6379"

If Redis is unavailable, the orchestrator automatically falls back to PostgreSQL-based polling. The orcher_postgres_fallback_total metric tracks fallback events.


Next Steps