PostgreSQL

PostgreSQL is an open source, object-relational database built with a focus on 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.

Quickstart

Just the essentials to go from zero to working in a few minutes.

How-Tos

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

Tutorials

Step-by-step instructions for common use cases and third-party software integration.

Reference

Native and third-party tools, troubleshooting, and answers to frequently asked questions.

Concepts

Explanations and definitions of core concepts in PostgreSQL.

Details

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

Support

Get help with technical support and answers to frequently asked questions.

Latest Updates

26 August 2022

• In App Platform, you can now create bindable environment variables for your PostgreSQL database connection pools. For detailed instructions, see our reference page.

27 June 2022

• In order to improve security, DigitalOcean no longer accepts TLS 1.0 and TLS 1.1 connections. This includes connections to www.digitalocean.com, cloud.digitalocean.com, and api.digitalocean.com.

4 March 2022

• You can now configure your MySQL, PostgreSQL, and Redis Managed Databases by making a PATCH request to /v2/databases/{database_cluster_uuid}/config. For example:

  {
    "config": {
      "sql_mode": "ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,STRICT_ALL_TABLES",
      "sql_require_primary_key": true
    }
  }
  

  For more details, see the full reference documentation for the managed databases API.

For more information, see all PostgreSQL release notes.