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.
Most Viewed PostgreSQL Articles
- When connecting to my database I get a Connection Timed Out error
- How to Modify User Privileges in PostgreSQL Databases
- When connecting to my database I get a Connection Refused error
- How to Connect to PostgreSQL Database Clusters
- How to Migrate PostgreSQL Databases
- How to Manage Connection Pools for PostgreSQL Database Clusters
- When connecting to PostgreSQL I get a Could Not Translate Hostname to Address error
- How to Monitor PostgreSQL Database Performance
- How to Upgrade PostgreSQL to a New Version
- PostgreSQL Pricing
Latest Updates
6 October 2023
-
PostgreSQL 11 is now deprecated. Starting on 6 November 2023, all existing PostgreSQL 11 database clusters will automatically upgrade to PostgreSQL 15 during the cluster’s upgrade window.
29 September 2023
-
When creating or resizing MySQL or PostgreSQL clusters on DigitalOcean, you can now add additional storage independently from your chosen database configuration plan. This provides a more economic option for increasing storage, rather than upgrading your cluster’s entire plan.
For more details, see our guides on how to resize MySQL clusters and resize PostgreSQL clusters.
-
The following MySQL and PostgreSQL plans are now deprecated:
- MySQL and PostgreSQL plans with 8 vCPUs, 32 GB RAM, and 600 GB SSD ($480 per month)
- MySQL and PostgreSQL plans with 16 vCPUs, 64 GB RAM, and 1220 GB SSD ($960 per month)
All of your existing database clusters with these plans are still functional and accessible to you. However, you cannot resize them. To regain access to these features, fork your database to a new cluster with a supported plan. For more detailed steps, see our guides on how to fork MySQL databases and fork PostgreSQL databases.
17 July 2023
-
PostgreSQL clusters on DigitalOcean now support the pgvector extension, for vector similarity search. For a full list of supported extensions, see our guide Supported PostgreSQL Extensions.
For more information, see all PostgreSQL release notes.