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.


Just the essentials to go from zero to working in a few minutes.
How to modify users and databases, improve performance and high availability, migrate data, and more.
Step-by-step instructions for common use cases and third-party software integration.
Native and third-party tools, troubleshooting, and answers to frequently asked questions.
Explanations and definitions of core concepts in PostgreSQL.
Features, plans and pricing, availability, limits, known issues, and more.
Get help with technical support and answers to frequently asked questions.

Latest Updates

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.

15 February 2022

For more information, see all PostgreSQL release notes.