PostgreSQL How-Tos

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.
Connect to PostgreSQL database clusters from the command line or other applications.
Import an existing PostgreSQL database into DigitalOcean Managed Databases.
Migrate an existing PostgreSQL database internally or from another provider to DigitalOcean.
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.
Organize PostgreSQL databases clusters with tags to group and filter databases or create monitoring alert policies for multiple databases at once.

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.
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.

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.