# PostgreSQL – DigitalOcean Documentation

> PostgreSQL is an open source, object-relational database built with extensibility, data integrity, and speed in mind. 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.
- [PostgreSQL Support](https://docs.digitalocean.com/products/databases/postgresql/support/index.html.md): Get help with technical support and answers to frequently asked questions.



## Getting Started with PostgreSQL

Quickstarts and intermediate tutorials to get started.

- [PostgreSQL Quickstart](https://docs.digitalocean.com/products/databases/postgresql/getting-started/quickstart/index.html.md): Just the essentials to go from zero to working in a few minutes.

## PostgreSQL How-Tos

How to modify users and databases, improve performance and high availability, migrate data, and more.

- [How to Create PostgreSQL Database Clusters](https://docs.digitalocean.com/products/databases/postgresql/how-to/create/index.html.md): Create a PostgreSQL database cluster from the DigitalOcean Control Panel.
- [How to Connect to PostgreSQL Database Clusters](https://docs.digitalocean.com/products/databases/postgresql/how-to/connect/index.html.md): Connect to PostgreSQL database clusters from the command line or other applications.
- [How to Resize PostgreSQL Database Clusters](https://docs.digitalocean.com/products/databases/postgresql/how-to/resize/index.html.md): Increase the size of your database cluster to accommodate your data needs.
- [How to Import PostgreSQL Databases into DigitalOcean Managed Databases with pg_dump](https://docs.digitalocean.com/products/databases/postgresql/how-to/import-databases/index.html.md): Import an existing PostgreSQL database into a DigitalOcean Managed Databases cluster.
- [How to Secure PostgreSQL Managed Database Clusters](https://docs.digitalocean.com/products/databases/postgresql/how-to/secure/index.html.md): Add additional security to a PostgreSQL managed database cluster by restricting incoming connections and increasing the SSL mode verification level.
- [How to Migrate PostgreSQL Databases to DigitalOcean using Continuous Migration](https://docs.digitalocean.com/products/databases/postgresql/how-to/migrate/index.html.md): Use continuous migration to move an existing non-DigitalOcean PostgreSQL database to DigitalOcean Managed Databases.
- [How to Schedule Automatic Software Updates for PostgreSQL Database Clusters](https://docs.digitalocean.com/products/databases/postgresql/how-to/schedule-updates/index.html.md): Customize the maintenance window for automatic software updates to your database cluster.
- [How to Manage PostgreSQL Users and Databases in a Database Cluster](https://docs.digitalocean.com/products/databases/postgresql/how-to/manage-users-and-databases/index.html.md): Create and delete a database cluster's databases and database users from the DigitalOcean Control Panel.
- [How to Modify User Privileges in PostgreSQL Databases](https://docs.digitalocean.com/products/databases/postgresql/how-to/modify-user-privileges/index.html.md): Modify user privileges in PostgreSQL managed database clusters, like creating a read-only user.
- [How to Monitor PostgreSQL Database Performance](https://docs.digitalocean.com/products/databases/postgresql/how-to/monitor-databases/index.html.md): Access and interpret PostgreSQL database performance metrics.
- [How to Add Standby Nodes to PostgreSQL Database Clusters](https://docs.digitalocean.com/products/databases/postgresql/how-to/add-standby-nodes/index.html.md): Add standby nodes to new or existing PostgreSQL database clusters for high availability.
- [How to Add Read-Only Nodes to PostgreSQL Database Clusters](https://docs.digitalocean.com/products/databases/postgresql/how-to/add-read-only-nodes/index.html.md): Add read-only nodes to reduce latency for users in specific regions.
- [How to Monitor PostgreSQL Database Cluster Performance](https://docs.digitalocean.com/products/databases/postgresql/how-to/monitor-clusters/index.html.md): Access and understand performance metrics for nodes in a database cluster.
- [How to Manage Connection Pools for PostgreSQL Database Clusters](https://docs.digitalocean.com/products/databases/postgresql/how-to/manage-connection-pools/index.html.md): Use connection pools to improve PostgreSQL database performance.
- [How to Set Up Cluster Monitoring Alerts](https://docs.digitalocean.com/products/databases/postgresql/how-to/set-up-alerts/index.html.md): Configure alert policies based on database cluster performance metrics.
- [How to Relocate Database Clusters](https://docs.digitalocean.com/products/databases/postgresql/how-to/relocate/index.html.md): Change a cluster's regional datacenter.
- [How to Forward Logs from a PostgreSQL Cluster](https://docs.digitalocean.com/products/databases/postgresql/how-to/forward-logs/index.html.md): Forward database logs to OpenSearch, Elasticsearch, or Rsyslog.
- [How to Fork a PostgreSQL Database Cluster](https://docs.digitalocean.com/products/databases/postgresql/how-to/fork-clusters/index.html.md): Fork a database cluster to create a new cluster from an existing cluster based on a specific point in time.
- [How to Manually Restore PostgreSQL Database Clusters from Backups](https://docs.digitalocean.com/products/databases/postgresql/how-to/restore-from-backups/index.html.md): Recover from accidental data loss by manually restoring a PostgreSQL database cluster from backups.
- [How to Destroy PostgreSQL Database Clusters](https://docs.digitalocean.com/products/databases/postgresql/how-to/destroy/index.html.md): Destroy a database cluster to permanently and irreversibly destroy the cluster, its contents, and its automated backups.
- [How to Tag Postgresql Database Clusters](https://docs.digitalocean.com/products/databases/postgresql/how-to/tag/index.html.md): Organize PostgreSQL databases clusters with tags to group and filter databases or create monitoring alert policies for multiple databases at once.
- [How to Upgrade PostgreSQL to a New Version](https://docs.digitalocean.com/products/databases/postgresql/how-to/upgrade-version/index.html.md): Upgrade your PostgreSQL cluster to the latest supported version of PostgreSQL from the control panel.
- [How to Reconfigure PostgreSQL Database Clusters](https://docs.digitalocean.com/products/databases/postgresql/how-to/reconfigure/index.html.md): Edit your database engine's configuration and parameters via the CLI or API.

## PostgreSQL Concepts

Explanations and definitions of core concepts in PostgreSQL.

- [Best Practices](https://docs.digitalocean.com/products/databases/postgresql/concepts/best-practices/index.html.md): Recommended practices to implement when setting up and running your PostgreSQL clusters.
- [Optimize Shared Buffers](https://docs.digitalocean.com/products/databases/postgresql/concepts/shared-buffers/index.html.md): Check and set the `shared_buffers` parameter based on available memory to improve cache hit ratio and reduce disk access.
- [Shared Responsibility Model](https://docs.digitalocean.com/products/databases/postgresql/concepts/responsibility-model/index.html.md): Description of DigitalOcean's responsibilities as a managed database provider.
- [Migration Strategies](https://docs.digitalocean.com/products/databases/postgresql/concepts/migration-strategies/index.html.md): Tips on how to transition to your new database upon migration.

## PostgreSQL Details

Features, plans and pricing, availability, limits, known issues, and more.

- [PostgreSQL Features](https://docs.digitalocean.com/products/databases/postgresql/details/features/index.html.md): Features for PostgreSQL database clusters.
- [PostgreSQL Pricing](https://docs.digitalocean.com/products/databases/postgresql/details/pricing/index.html.md): Pricing for PostgreSQL database clusters.
- [PostgreSQL Availability](https://docs.digitalocean.com/products/databases/postgresql/details/availability/index.html.md): Regional datacenter availability for PostgreSQL database clusters.
- [PostgreSQL Limits](https://docs.digitalocean.com/products/databases/postgresql/details/limits/index.html.md): Limits and known issues for PostgreSQL database clusters.
- [Supported PostgreSQL Extensions](https://docs.digitalocean.com/products/databases/postgresql/details/supported-extensions/index.html.md): A list of the PostgreSQL extensions supported by DigitalOcean PostgreSQL managed databases and how to manage them.
- [Types of Cluster Notifications](https://docs.digitalocean.com/products/databases/postgresql/details/notifications/index.html.md): Common alerts you might receive about your database cluster's performance.