
Managed PostgreSQL
Running your own Postgres means patching security vulnerabilities, configuring backups, monitoring disk space, and waking up at 3am when replication breaks. Gigalixir's managed databases run on Google Cloud SQL with automatic maintenance, daily backups retained for 7 days, and one-command scaling. Your DATABASE_URL gets set automatically when you provision. SSL is enabled by default. Connection limits scale with your database size so Ecto's connection pool works without constant tuning. Start with a free tier database for development, then upgrade to standard tier for production with a single CLI command.
Automatic Backups and Recovery: Standard tier databases back up daily with 7 days of retention. Restore to any backup with gigalixir pg:backups:restore. No cron jobs to configure. No backup scripts to maintain. No panic when someone runs a bad migration.
Scaling Without Downtime Planning: Resize your database from 0.6GB to 96GB of memory as your application grows. Connection limits scale proportionally. Disk space grows automatically with usage. You don't need to predict your storage needs months in advance.
Ecto-Friendly Configuration: We set sensible defaults for pool_size based on your database tier and replica count. The connection string works with Ecto out of the box. SSL is configured so you don't have to figure out certificate verification in your repo config.
Full Admin Access: Standard tier gives you administrative privileges. Create users and roles, grant permissions, install extensions, create views. It's your database. We just handle the infrastructure.
