Production-grade PostgreSQL HA for Rails.
- High Availability: Primary/standby replication with automatic failover (repmgr)
- Connection Pooling: PgBouncer integration
- Rails Integration: Automatic database.yml config, migration guard, read replica routing
- Modular Components: Core, Performance Tuning, repmgr, PgBouncer, pgBackRest, Monitoring, SSL, Extensions
gem install active_postgres
# or add to Gemfile: gem 'active_postgres'rails generate active_postgres:installEdit config/postgres.yml:
production:
version: 18
user: ubuntu
ssh_key: ~/.ssh/id_rsa
primary:
host: 34.12.234.81 # Public IP for SSH
private_ip: 10.8.0.10 # Private IP for database connections
standby:
- host: 52.23.45.67
private_ip: 10.8.0.11
components:
repmgr: {enabled: true}
pgbouncer: {enabled: true}
secrets:
superuser_password: $POSTGRES_SUPERUSER_PASSWORD
replication_password: $POSTGRES_REPLICATION_PASSWORD
repmgr_password: $POSTGRES_REPMGR_PASSWORD
app_password: $POSTGRES_APP_PASSWORDAdd credentials (rails credentials:edit):
postgres:
username: myapp
password: "your_app_password"
database: myapp_production
primary_host: 10.8.0.10
replica_host: 10.8.0.11
port: 6432 # 6432 for PgBouncer, 5432 for directrake postgres:setup # Deploy cluster
rake postgres:status # Check healthrake postgres:setup # Deploy HA cluster
rake postgres:status # Check cluster status
rake postgres:verify # Comprehensive health check
rake postgres:promote[host] # Promote standby to primary
# Backups (requires pgBackRest)
rake postgres:backup:full
rake postgres:backup:list
rake postgres:backup:restore[backup_id]
# Credential rotation (zero downtime)
rake postgres:credentials:rotate_random
rake postgres:credentials:rotate_all
# Rolling updates (zero downtime)
rake postgres:update:version[18] # Major version upgrade
rake postgres:update:patch # Security patchesactive_postgres setup --environment=production
active_postgres setup-standby HOST
active_postgres status
active_postgres promote HOST
active_postgres backup --type=full
active_postgres cache-secrets| Component | Description | Config |
|---|---|---|
| Core | PostgreSQL installation | Always enabled |
| Performance Tuning | Auto-optimization | Enabled by default |
| repmgr | HA & automatic failover | repmgr: {enabled: true} |
| PgBouncer | Connection pooling | pgbouncer: {enabled: true} |
| pgBackRest | Backup & restore | pgbackrest: {enabled: true} |
| Monitoring | postgres_exporter | monitoring: {enabled: true} |
| SSL | Encrypted connections | ssl: {enabled: true} |
| Extensions | pgvector, PostGIS, etc. | extensions: {enabled: true, list: [pgvector]} |
secrets:
# Environment variables
password: $POSTGRES_PASSWORD
# Command execution
password: $(op read "op://vault/item/field")
password: $(rails runner "puts Rails.application.credentials.dig(:postgres, :password)")
# AWS Secrets Manager
password: $(aws secretsmanager get-secret-value --secret-id myapp/postgres --query SecretString)class ApplicationRecord < ActiveRecord::Base
connects_to database: { writing: :primary, reading: :primary_replica }
end
# Writes go to primary, reads go to replica
User.create(name: "Alice") # → Primary
User.all # → Replica- Ruby 3.0+
- PostgreSQL 12+
- Ubuntu 20.04+ / Debian 11+ with systemd
- SSH key-based authentication
- Rails 6.0+ (optional)
MIT
