PostgreSQL How-Tos

Generated on 3 Jul 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

New Project
How to Create PostgreSQL Database Clusters

Create a PostgreSQL database cluster from the DigitalOcean Control Panel.

New Project
How to Create PostgreSQL Advanced Edition Clusters

PostgreSQL Advanced Edition public preview documentation.

New Project
How to Connect to PostgreSQL Database Clusters

Connect to PostgreSQL database clusters from the command line or other applications.

New Project
Import Databases

Import an existing PostgreSQL database into a DigitalOcean Managed Databases cluster.

New Project
How to Secure PostgreSQL Managed Database Clusters

Add additional security to a PostgreSQL managed database cluster by restricting incoming connections and increasing the SSL mode verification level.

New Project
Migrate External Databases

Use continuous migration to move an existing non-DigitalOcean PostgreSQL database to DigitalOcean Managed Databases.

New Project
How to Migrate from Managed to Self-Managed PostgreSQL

Copy databases from a DigitalOcean Managed PostgreSQL cluster to a PostgreSQL instance you run.

New Project
How to Schedule Automatic Software Updates for PostgreSQL Database Clusters

Customize the maintenance window for automatic software updates to your database cluster.

New Project
How to Tag PostgreSQL Database Clusters

Organize PostgreSQL databases clusters with tags to group and filter databases or create monitoring alert policies for multiple databases at once.

Cluster Infrastructure

New Project
How to Resize PostgreSQL Database Clusters

Change the size of your database cluster to accommodate your data needs.

New Project
How to Monitor PostgreSQL Database Performance

Access and interpret PostgreSQL database and cluster performance metrics.

New Project
How to Add Standby Nodes to PostgreSQL Database Clusters

Add standby nodes to new or existing PostgreSQL database clusters for high availability.

New Project
How to Add Read-Only Nodes to PostgreSQL Database Clusters

Add read-only nodes to reduce latency for users in specific regions.

New Project
How to Manage Connection Pools for PostgreSQL Database Clusters

Use connection pools to improve PostgreSQL database performance.

New Project
How to Set Up PostgreSQL Cluster Monitoring Alerts

Configure alert policies based on database cluster performance metrics.

New Project
How to Forward Logs from a PostgreSQL Cluster

Forward database logs to OpenSearch, Elasticsearch, or Rsyslog.

PostgreSQL Management

New Project
How to Manage PostgreSQL Users and Databases in a Database Cluster

Create and delete a database cluster’s databases and database users from the DigitalOcean Control Panel.

New Project
How to Modify User Privileges in PostgreSQL Databases

Modify user privileges in PostgreSQL managed database clusters, like creating a read-only user.

New Project
How to Upgrade PostgreSQL to a New Version

Upgrade your PostgreSQL cluster to the latest supported version of PostgreSQL from the control panel.

New Project
How to Reconfigure PostgreSQL Database Clusters

Edit your database engine’s configuration and parameters via the CLI or API.

Cluster Management

New Project
How to Relocate Database Clusters

Change a cluster’s regional datacenter.

New Project
How to Configure Custom CNAME Records for PostgreSQL Clusters

Assign custom domain names to PostgreSQL Standard Edition clusters using the DigitalOcean API.

New Project
How to Fork a PostgreSQL Database Cluster

Fork a database cluster to create a new cluster from an existing cluster based on a specific point in time.

New Project
How to Manually Restore PostgreSQL Database Clusters from Backups

Recover from accidental data loss by manually restoring a PostgreSQL database cluster from backups.

New Project
How to Destroy PostgreSQL Database Clusters

Destroy a database cluster to permanently and irreversibly destroy the cluster, its contents, and its automated backups.

We can't find any results for your search.

Try using different keywords or simplifying your search terms.