PostgreSQL How-To Guides

Getting Started

Create a PostgreSQL database cluster from the DigitalOcean Control Panel.
Connect to PostgreSQL database clusters with psql, the PostgreSQL interactive terminal.
Import an existing PostgreSQL database into DigitalOcean Managed Databases.
Add additional security to a PostgreSQL managed database cluster by restricting incoming connections and increasing the SSL mode verification level.
Customize the maintenance window for automatic software updates to your database cluster.

PostgreSQL Management

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.
Access and interpret PostgreSQL database performance metrics.

Cluster Infrastructure

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.
Access and understand performance metrics for nodes in a database cluster.
Configure alert policies based on database cluster performance metrics.

Cluster Management

Fork a database cluster to create a new cluster from an existing cluster based on a specific point in time.
Recover from accidental data loss by manually restoring a PostgreSQL database cluster from backups.
Destroy a database cluster to permanently and irreversibly destroy the cluster, its contents, and its automated backups.