{"id":6760,"date":"2023-09-30T09:00:35","date_gmt":"2023-09-30T16:00:35","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/cosmosdb\/?p=6760"},"modified":"2023-09-29T07:09:10","modified_gmt":"2023-09-29T14:09:10","slug":"postgres-16-in-azure-cosmos-db-for-postgresql-2","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/cosmosdb\/postgres-16-in-azure-cosmos-db-for-postgresql-2\/","title":{"rendered":"Postgres 16 available in Azure Cosmos DB for PostgreSQL, powered by Citus"},"content":{"rendered":"

Big news in the Postgres world:\u00a0PostgreSQL 16<\/a> was released just over 2 weeks ago. And today we’re announcing that Postgres 16 is\u00a0generally available\u00a0for production\u00a0workloads on Azure Cosmos DB for PostgreSQL<\/a>. That\u2019s right,\u00a0in production:\u00a0this announcement\u00a0is not just a\u00a0preview of Postgres 16 support.<\/span>\u00a0<\/span><\/p>\n

Whether you need to provision a new distributed Postgres cluster in Azure Cosmos DB for PostgreSQL\u2014or upgrade your existing database clusters\u2014Postgres 16 is now an option for you.\u00a0<\/span>\u00a0<\/span><\/p>\n

And you can use <\/span>Azure Portal<\/span><\/a>, <\/span>Bicep<\/span><\/a> or <\/span>ARM templates<\/span><\/a>, <\/span>REST APIs<\/span><\/a>, <\/span>Azure SDKs<\/span><\/a>, or <\/span>Azure CLI<\/span><\/a> to spin up a new Postgres 16 cluster in Azure Cosmos DB for PostgreSQL, or to upgrade an existing cluster to Postgres 16.<\/span>\u00a0<\/span><\/p>\n

PostgreSQL 16 + Citus 12 now available in Azure Cosmos DB for PostgreSQL <\/span><\/b>\u00a0<\/span><\/h3>\n

Giving you access to new capabilities in Postgres is a priority for the Azure Cosmos DB for PostgreSQL team. And because Citus\u2014which powers Azure Cosmos DB for PostgreSQL\u2014is an <\/span>open source database extension<\/span><\/a> (and not a fork!), it makes it easier for us to keep Azure Cosmos DB for PostgreSQL current with the latest Postgres releases.\u00a0<\/span>\u00a0<\/span><\/p>\n

A lot of focused engineering work to keep up-to-date with the Postgres 16 beta and RC candidate releases over the last months allowed to bring all Postgres 16 benefits to Citus extension and Azure Cosmos DB for PostgreSQL that fast. In fact, the <\/span>Citus 12.1 open source release<\/span><\/a> came out with Postgres 16 support just 1 week after the Postgres 16 release.<\/span><\/p>\n

Of course, making Azure Cosmos DB for PostgreSQL available on the latest versions of Postgres also involves a rigorous QA process, too. <\/span>Here are some details<\/span><\/a> about the QA and release process published last year for Azure Cosmos DB for PostgreSQL, shortly after Postgres 15 was released.<\/span>\u00a0<\/span><\/p>\n

Lots of improvements, small and large, in Postgres 16<\/span><\/b>\u00a0<\/span><\/h3>\n

Highlights of the innovations featured in the <\/span>PostgreSQL 16 release notes<\/span><\/a> (that many of us are excited about) include:<\/span>\u00a0<\/span><\/p>\n