Postgres

Managed PostgreSQL runs PostgreSQL 15 to 18 on machines in your region: a single node or a three-node cluster with automatic failover behind one address, a connection pooler on every port, TLS by default, daily encrypted backups with point-in-time restore, and masked copy-on-write branches for pull requests and previews.

Get started

  • What is Managed PostgreSQL?

    Managed PostgreSQL runs PostgreSQL databases for you on machines in your region, single node or as a three-node cluster with automatic failover.

  • Get started with Managed PostgreSQL

    Create a single-node database, read its password, connect with psql over TLS, and delete it again, in about ten minutes.

  • Instances, clusters and endpoints

    A database is a single node or a three-node cluster, reached at one endpoint on direct and pooled ports, from its network or from the internet.

Popular tasks

  • Create a database

    Create a PostgreSQL database, single node or a three-node cluster, in a private network or reachable from the internet.

  • Connect to a database

    Connect over TLS with the connection strings on the Connection tab, and verify the server with the platform's CA bundle.

  • Restore a database

    Build a new database from a database's backups, to the latest moment, to a second in the recovery window, or to the end of one backup.

  • Create a branch

    Cut a masked, writable copy of a database in seconds, connect to it, and delete it when you are done.

Operate and secure

  • Security in Managed PostgreSQL

    Who may do what (IAM), what is audited, how data is encrypted at rest, in backups and in transit, and who can reach a database.

  • Monitoring Managed PostgreSQL

    Metrics and alarms, replication lag, the health problems you are mailed about, and the Activity stream of every database.

  • How Managed PostgreSQL behaves when things fail

    What your application sees when a machine, the network, a disk or the database process fails, how long it lasts, whether committed data can be lost, and what the platform tells you.

Guides and references