• Managed Databases
• [postgresql.855c43f1f82e98a24a05998729b39a9937438c7f77af3dc0c22da5a5739f5eb7.svg]PostgreSQL
• Getting Started
  • Quickstart
• How-Tos
  • Create PostgreSQL Clusters
  • Create PostgreSQL Advanced Edition Clusters public
  • Connect to PostgreSQL Cluster
  • Secure PostgreSQL Clusters
  • Migrate Databases
  • Manage Users
    • Manage Users and Databases
    • Modify User Privileges
  • Monitor
    • Monitor PostgreSQL Performance
    • Set Up Monitoring Alerts
    • Forward Logs
    • Monitor with PMM 1-Click App
  • Scale Cluster
    • Resize Database Clusters
    • Add Standby Nodes
    • Add Read-Only Nodes
    • Manage Connection Pools
  • Manage Cluster
    • Schedule Automatic Updates
    • Tag Database Clusters
    • Relocate Database Clusters
    • Configure Custom CNAMEs
    • Fork Database Clusters
    • Restore from Backups
    • Upgrade PostgreSQL
    • Reconfigure Database Clusters
    • Migrate to Self-Managed PostgreSQL
    • Destroy Database Clusters
• Reference
  • API Reference
  • CLI Reference
  • MCP Reference
• Concepts
  • Best Practices
  • Migration Strategies
  • Shared Buffers
  • Shared Responsibility Model
• Details
  • Features
  • Pricing
  • Availability
  • Limits
  • Supported Extensions
  • Cluster Notifications
  • Service-Level Agreement
• Support

For AI agents: The documentation index is at https://docs.digitalocean.com/llms.txt. Markdown versions of pages use the same URL with index.html.md in place of the HTML page (for example, append index.html.md to the directory path instead of opening the HTML document).

PostgreSQL Features

Last verified 17 Jun 2025

PostgreSQL is an open source, object-relational database built for extensibility, data integrity, and speed. Its concurrency support makes it fully ACID-compliant, and it supports dynamic loading and catalog-driven operations to let users customize its data types, functions, and more.

Managed Database Cluster Features

• Automatic updates. You can select a weekly date and time during which the database checks and applies updates to its operating system and engine to keep the service stable and secure.

• Daily point-in-time backups. Full cluster backups are taken daily and write-ahead-logs are maintained to allow you to restore to any point-in-time within the previous seven days.

• High availability with automated failover. In the event of a failure, managed databases with a standby node will automatically switch data handling to the standby node to prevent unplanned downtime. Learn more about high availability for managed databases.

• End-to-end security. Encrypts data at rest with LUKS and in transit with SSL.

• Cluster metrics and alerting. Cluster metrics visualizations help you monitor the performance of the nodes in a database cluster, like resource usage, to guide capacity planning and optimization. Alert policies notify you when a metric rises above or falls below a threshold you set, like high CPU or low memory.

PostgreSQL Features

• Read-only nodes. You can add read-only nodes in geographically disparate datacenters.

• Database metrics and query insights. PostgreSQL-specific performance metrics help you assess the health of the database, pinpoint performance bottlenecks, and identify unusual use patterns that may indicate an application bug or security breach.

  PostgreSQL database metrics include number of database connections, cache hit ratio, deadlock creation rate, and fetch, insert, delete, and update throughput.

---