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.
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
.
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.
PostgreSQL 14 is now available for database clusters. You can upgrade earlier versions of PostgreSQL clusters to newer versions without any downtime using the DigitalOcean Control Panel.
For more information, see all PostgreSQL release notes.