PostgreSQL

RunOS provisions PostgreSQL through CloudNativePG in your RunOS cluster. Your app can connect with a standard PostgreSQL driver. Use PostgreSQL for application data that needs transactions, such as accounts, orders, and permissions.

Choose how to run it

• Start with one replica for development or a workload that can tolerate an outage.
• Choose a multi-replica tier for a primary and streaming standbys. Place replicas on separate nodes.
• Configure backups to an S3-compatible destination. Test a restore before you rely on the schedule.
• Enable extensions such as pgvector when the application needs them.

Connect your application

Create PostgreSQL in the RunOS Console or CLI. Add the service as a dependency in runos.yaml to pass the connection settings to your app. If you bring an existing database, plan the data transfer and rehearse the cutover separately from the application deployment.

See the database guide for how to choose between PostgreSQL, MySQL, and ClickHouse. For application wiring and storage, use the managed services documentation.