- How-Tos
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.mdin place of the HTML page (for example, appendindex.html.mdto the directory path instead of opening the HTML document).
PostgreSQL How-Tos
Generated on 19 Aug 2026
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.
Getting Started
[]
Create a PostgreSQL database cluster from the DigitalOcean Control Panel.
[]
PostgreSQL Advanced Edition public preview documentation.
[]
Connect to PostgreSQL database clusters from the command line or other applications.
[]
Secure PostgreSQL managed database clusters by restricting inbound connections with trusted sources and strengthening TLS verification with sslmode settings.
[]
Move an existing PostgreSQL database to DigitalOcean Managed Databases with continuous migration or a pg_dump import.
Manage Users
[]
Create and delete a database cluster’s databases and database users from the DigitalOcean Control Panel.
[]
Modify user privileges in PostgreSQL managed database clusters, like creating a read-only user.
Monitor
[]
Access and interpret PostgreSQL database and cluster performance metrics.
[]
Configure alert policies based on database cluster performance metrics.
[]
Forward database logs to OpenSearch, Elasticsearch, or Rsyslog.
[]
Add Managed PostgreSQL Standard Edition clusters to PMM using the Marketplace 1-Click PMM Integration helper.
Scale Cluster
[]
Change the size of your database cluster to accommodate your data needs.
[]
Add standby nodes to new or existing PostgreSQL database clusters for high availability.
[]
Add read-only nodes to reduce latency for users in specific regions.
[]
Use connection pools to improve PostgreSQL database performance.
Manage Cluster
[]
Customize the maintenance window for automatic software updates to your database cluster.
[]
Organize PostgreSQL databases clusters with tags to group and filter databases or create monitoring alert policies for multiple databases at once.
[]
Change a cluster’s regional datacenter.
[]
Assign custom domain names to PostgreSQL Standard Edition clusters using the DigitalOcean API.
[]
Fork a PostgreSQL database cluster to create a new cluster from a point in time or the latest transaction.
[]
Recover from accidental data loss by manually restoring a PostgreSQL database cluster from backups.
[]
Upgrade your PostgreSQL cluster to the latest supported version of PostgreSQL from the control panel.
[]
Edit your database engine’s configuration and parameters via the CLI or API.
[]
Copy databases from a DigitalOcean Managed PostgreSQL cluster to a PostgreSQL instance you run.
[]
Destroy a database cluster to permanently and irreversibly destroy the cluster, its contents, and its automated backups.
![[postgresql.855c43f1f82e98a24a05998729b39a9937438c7f77af3dc0c22da5a5739f5eb7.svg]](https://docs.digitalocean.com/images/icons/postgresql.855c43f1f82e98a24a05998729b39a9937438c7f77af3dc0c22da5a5739f5eb7.svg){kind=link}
![[]](https://docs.digitalocean.com/flourish-7.svg){kind=link}
![[]](https://docs.digitalocean.com/flourish-frame.svg){kind=link}
![[]](https://docs.digitalocean.com/flourish-2.svg){kind=link}
![[]](https://docs.digitalocean.com/flourish-1.svg){kind=link}
![[]](https://docs.digitalocean.com/flourish-9.svg){kind=link}
![[]](https://docs.digitalocean.com/flourish-6.svg){kind=link}
![[]](https://docs.digitalocean.com/flourish-4.svg){kind=link}
![[]](https://docs.digitalocean.com/flourish-3.svg){kind=link}
![[]](https://docs.digitalocean.com/flourish-5.svg){kind=link}
![[]](https://docs.digitalocean.com/flourish-8.svg){kind=link}