Skip to main content

PostgreSQL

Most gen3 services rely on PostgreSQL for relational data storage. This includes services like Fence, Peregrine, and more.

PostgreSQL is required to provide:

  • Relational data storage
  • Transaction support
  • Advanced data types
  • Performance at scale
  • Reliability and backups

For production deployments, a managed PostgreSQL service is recommended:

  • On AWS: RDS or Aurora
  • On Google Cloud: Cloud SQL
  • On Azure: Azure Database for PostgreSQL

Using a fully managed PostgreSQL service avoids the overhead of maintaining PostgreSQL and simplifies operations.