← All docs

Amazon RDS for PostgreSQL

Amazon RDS manages PostgreSQL instances with automated backups, failover, and scaling.

Connection

Use the RDS endpoint as your database URL. Ensure your security group allows connections from your CI environment.

Setup

# Connection string format
postgresql://user:password@mydb.abcdef.us-east-1.rds.amazonaws.com:5432/mydb

# Analyze with production context (Pro)
migrationpilot analyze migration.sql \
  --database-url "postgresql://user:pass@mydb.cluster-abc.us-east-1.rds.amazonaws.com/mydb" \
  --license-key $MIGRATIONPILOT_LICENSE

Tips

  • •RDS enforces statement_timeout at the parameter group level — verify your migration timeout settings
  • •Multi-AZ deployments add replication lag to DDL operations
  • •Use RDS Proxy for connection pooling in high-traffic environments
  • •RDS Performance Insights can help identify high-traffic tables for MP013/MP014 thresholds
← All docsConfiguration guide