Skip to main content

PostgreSQL

As a Project administrator or developer, use these guides to create and operate a managed PostgreSQL database. Select a published plan for the version, capacity, availability, and recovery support your application needs.

Create and connect​

Start with the creation and connection procedures:

  1. Create a PostgreSQL service with a manifest, or use the console.
  2. Connect applications through a binding with verified TLS.
  3. Configure credentials and rotation for declared roles or supported existing SQL logins.

PostgreSQL provides a primary endpoint, replica endpoints, and optional PgBouncer pooling. Endpoint selection and credential roles are independent. See the connection guide for availability checks and client examples.

Operate and recover​

Choose the guide for your task:

TaskGuide
Scale replicas, resize compute, expand storage, change settings, or upgradePostgreSQL operations
Schedule backups, restore into another service, restore in place, or choose a recovery timePostgreSQL backups and recovery
Connect from outside the Project through a supported GatewayPostgreSQL external access
Remove a database or inspect retained resourcesPostgreSQL deletion

Plan entitlement and service state determine which actions you can request. Test recovery before you rely on backups, and check the documented limits for each operation.

Shared managed service tasks​

The same platform rules apply to PostgreSQL and other service families: