This blog post provides a high-level overview of our service, powered by open source Citus and PostgreSQL; and shares some of its key features.<\/p>\n
Azure Cosmos DB for PostgreSQL<\/span><\/h2>\nAzure Cosmos DB for PostgreSQL is the first managed database that brings together a combination of three key properties:<\/p>\n
\n- True PostgreSQL, with latest versions<\/strong>: We work with and contribute to open-source PostgreSQL. This way, you don\u2019t get a partial API. You get the full familiarity and benefits of PostgreSQL, within two weeks of each release.<\/li>\n
- Cloud database<\/strong>: Benefit from a broad range of managed database features \u2013 so that you don\u2019t have to worry about your database again. For example, you can create high availability configurations across availability zones, fork or restore your cluster to a particular point in time, or one-click upgrade your PostgreSQL & database extensions.<\/li>\n
- Start small, scale globally\u2014powered by Citus<\/strong>: Start testing your apps with a Free Trial. As your workload grows, scale it out by enabling distributed tables, powered by the Citus open source<\/a> extension to PostgreSQL. This way, we\u2019ll take care of relational features at scale \u2013 distributed transactions, deadlocks, foreign keys, and more \u2013 for you. If you need to go global, enable cross-region replication for lower latency & global availability.<\/li>\n<\/ol>\n
If you\u2019re just starting with Azure Cosmos DB, let\u2019s see how you can benefit from these three properties with a few examples.<\/p>\n
Free trial<\/span><\/h2>\nThe Azure Cosmos DB free trial<\/a> is the easiest way to get started in building your cloud-native app. With this feature, you get all the native capabilities that comes with PostgreSQL<\/a>, including rich JSON support<\/a>, powerful indexing<\/a>, extensive datatypes, full text search, and much more. Furthermore, as PostgreSQL releases new versions, we make those versions available to you within two weeks. This way, you can benefit from the latest features in PostgreSQL without delays.<\/p>\n![\"Image](\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/10\/Free-Trial-quickstart-1024x698.png\")
<\/a>Use Quick start in Azure portal to set up Azure Cosmos DB for PostgreSQL<\/figcaption><\/figure><\/p>\n <\/p>\n
Of course, Free Trial is enough to get started but you\u2019ll need more as your application gets more serious. When this happens, you can click the Upgrade button to enable a broad range of new features.<\/p>\n
Your cloud-native database<\/span><\/h2>\nUpgrading from the free trial, or creating a new database for PostgreSQL<\/a>, gives you many new capabilities. Example features include:<\/p>\n\n- High Availability across Availability Zones (AZ)<\/li>\n
- Automatic backup\/restore & ability to rewind to a particular point-in-time<\/li>\n
- One-click upgrade to latest PostgreSQL & extension versions<\/li>\n
- Scale up\/down your CPU and storage resources<\/li>\n
- Encryption at rest and private endpoints<\/li>\n
- Compliance with global and local certifications across 30 Azure regions<\/li>\n
- Global distribution across Azure regions to tolerate regional failures<\/li>\n
- And more<\/li>\n<\/ul>\n
![\"Image](\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/10\/Overview-screen-Portal-1024x817.png\")
<\/a>Configure your account and explore features in the Azure portal<\/figcaption><\/figure><\/p>\n <\/p>\n
With these features, you get managed database capabilities native to the cloud. We also provide cloud integrations so that you have an easier time building on Azure.<\/p>\n
Azure cloud integrations<\/span><\/h2>\nAnother key feature of a cloud-native database is how well it integrates with the rest of the cloud. Prior to today, if you had data in Azure Blob Storage<\/a>, you\u2019d need to download that data to another VM and then upload it to your database. This introduced unnecessary friction when you were building your application.<\/p>\nStarting now, you can directly interface with Azure Blob Storage through a brand-new PostgreSQL extension, pg_azure_storage<\/a>. After connecting to your PostgreSQL database, you just need to run the following commands:<\/p>\nSELECT create_extension('azure_storage');\r\nSELECT azure_storage.account_add('mystorageaccount', 'SECRET_ACCESS_KEY');\r\n\r\nCREATE TABLE github_events\r\n(\r\n event_id bigint,\r\n event_type text,\r\n event_public boolean,\r\n repo_id bigint,\r\n payload jsonb,\r\n repo jsonb,\r\n user_id bigint,\r\n org jsonb,\r\n created_at timestamp\r\n);\r\n\r\nCOPY github_events FROM 'https:\/\/mystorageaccount.blob.core.windows.net\/data\/github_events.csv' WITH (format 'csv');<\/pre>\nWith pg_azure_storage, you can also make modifications as you\u2019re ingesting data from Azure Blob Storage using user-defined functions. For a detailed list of all features, you can refer to our documentation here<\/a>.<\/p>\nWith these cloud-native capabilities, you can build your application with ease. And better yet, you can build your applications ready for running at any scale.<\/span><\/span><\/span>\u00a0<\/span><\/span><\/span>For this, <\/span>our service<\/span> for PostgreSQL <\/span>has <\/span>the<\/span> <\/span>Citus extension<\/span><\/span><\/a> built-in <\/span>and <\/span>allows you to <\/span>scale-out<\/span> your database<\/span> without limitations.<\/span><\/span> Packaged as a fully <\/span>open-source<\/span> extension, <\/span>Citus<\/span> extends PostgreSQL with the power of distributed tables, enabling distributed query execution and\u00a0<\/span><\/span><\/span>performance at scale. <\/span><\/span><\/span>Citus<\/span><\/a> does this while preserving true PostgreSQL at its core, with support for JSONB, geospatial, rich indexing, relational semantics, and more.<\/span><\/span><\/span><\/p>\nPostgres with the power of distributed tables<\/span><\/h2>\nWith our service for PostgreSQL, you can start building your apps on a single node server group, the same way you would with PostgreSQL. As your app\u2019s scalability and performance requirements grow, you can enable distributed tables and seamlessly scale to multiple nodes.<\/p>\n
Azure Cosmos DB makes this transition \u2013 enabling distributed tables \u2013 easy. Previously, if you wanted to use the Citus extension to create a distributed table, you\u2019d first have to pick a sharding key. You\u2019d then have to run a command that would block write operations. With Citus 11.1<\/a>, creating a distributed table and many previously write blocking operations, become fully online.<\/p>\nIf you want to see how this online operation works, you\u2019ll love this 1-minute video<\/strong>.<\/p>\n
If you\u2019re just starting with Azure Cosmos DB, let\u2019s see how you can benefit from these three properties with a few examples.<\/p>\n
Free trial<\/span><\/h2>\nThe Azure Cosmos DB free trial<\/a> is the easiest way to get started in building your cloud-native app. With this feature, you get all the native capabilities that comes with PostgreSQL<\/a>, including rich JSON support<\/a>, powerful indexing<\/a>, extensive datatypes, full text search, and much more. Furthermore, as PostgreSQL releases new versions, we make those versions available to you within two weeks. This way, you can benefit from the latest features in PostgreSQL without delays.<\/p>\n<\/a>Use Quick start in Azure portal to set up Azure Cosmos DB for PostgreSQL<\/figcaption><\/figure><\/p>\n <\/p>\n
Of course, Free Trial is enough to get started but you\u2019ll need more as your application gets more serious. When this happens, you can click the Upgrade button to enable a broad range of new features.<\/p>\n
Your cloud-native database<\/span><\/h2>\nUpgrading from the free trial, or creating a new database for PostgreSQL<\/a>, gives you many new capabilities. Example features include:<\/p>\n\n- High Availability across Availability Zones (AZ)<\/li>\n
- Automatic backup\/restore & ability to rewind to a particular point-in-time<\/li>\n
- One-click upgrade to latest PostgreSQL & extension versions<\/li>\n
- Scale up\/down your CPU and storage resources<\/li>\n
- Encryption at rest and private endpoints<\/li>\n
- Compliance with global and local certifications across 30 Azure regions<\/li>\n
- Global distribution across Azure regions to tolerate regional failures<\/li>\n
- And more<\/li>\n<\/ul>\n
<\/a>Configure your account and explore features in the Azure portal<\/figcaption><\/figure><\/p>\n <\/p>\n
With these features, you get managed database capabilities native to the cloud. We also provide cloud integrations so that you have an easier time building on Azure.<\/p>\n
Azure cloud integrations<\/span><\/h2>\nAnother key feature of a cloud-native database is how well it integrates with the rest of the cloud. Prior to today, if you had data in Azure Blob Storage<\/a>, you\u2019d need to download that data to another VM and then upload it to your database. This introduced unnecessary friction when you were building your application.<\/p>\nStarting now, you can directly interface with Azure Blob Storage through a brand-new PostgreSQL extension, pg_azure_storage<\/a>. After connecting to your PostgreSQL database, you just need to run the following commands:<\/p>\nSELECT create_extension('azure_storage');\r\nSELECT azure_storage.account_add('mystorageaccount', 'SECRET_ACCESS_KEY');\r\n\r\nCREATE TABLE github_events\r\n(\r\n event_id bigint,\r\n event_type text,\r\n event_public boolean,\r\n repo_id bigint,\r\n payload jsonb,\r\n repo jsonb,\r\n user_id bigint,\r\n org jsonb,\r\n created_at timestamp\r\n);\r\n\r\nCOPY github_events FROM 'https:\/\/mystorageaccount.blob.core.windows.net\/data\/github_events.csv' WITH (format 'csv');<\/pre>\nWith pg_azure_storage, you can also make modifications as you\u2019re ingesting data from Azure Blob Storage using user-defined functions. For a detailed list of all features, you can refer to our documentation here<\/a>.<\/p>\nWith these cloud-native capabilities, you can build your application with ease. And better yet, you can build your applications ready for running at any scale.<\/span><\/span><\/span>\u00a0<\/span><\/span><\/span>For this, <\/span>our service<\/span> for PostgreSQL <\/span>has <\/span>the<\/span> <\/span>Citus extension<\/span><\/span><\/a> built-in <\/span>and <\/span>allows you to <\/span>scale-out<\/span> your database<\/span> without limitations.<\/span><\/span> Packaged as a fully <\/span>open-source<\/span> extension, <\/span>Citus<\/span> extends PostgreSQL with the power of distributed tables, enabling distributed query execution and\u00a0<\/span><\/span><\/span>performance at scale. <\/span><\/span><\/span>Citus<\/span><\/a> does this while preserving true PostgreSQL at its core, with support for JSONB, geospatial, rich indexing, relational semantics, and more.<\/span><\/span><\/span><\/p>\nPostgres with the power of distributed tables<\/span><\/h2>\nWith our service for PostgreSQL, you can start building your apps on a single node server group, the same way you would with PostgreSQL. As your app\u2019s scalability and performance requirements grow, you can enable distributed tables and seamlessly scale to multiple nodes.<\/p>\n
Azure Cosmos DB makes this transition \u2013 enabling distributed tables \u2013 easy. Previously, if you wanted to use the Citus extension to create a distributed table, you\u2019d first have to pick a sharding key. You\u2019d then have to run a command that would block write operations. With Citus 11.1<\/a>, creating a distributed table and many previously write blocking operations, become fully online.<\/p>\nIf you want to see how this online operation works, you\u2019ll love this 1-minute video<\/strong>.<\/p>\n
<\/p>\n Of course, Free Trial is enough to get started but you\u2019ll need more as your application gets more serious. When this happens, you can click the Upgrade button to enable a broad range of new features.<\/p>\n Upgrading from the free trial, or creating a new database for PostgreSQL<\/a>, gives you many new capabilities. Example features include:<\/p>\n <\/p>\n With these features, you get managed database capabilities native to the cloud. We also provide cloud integrations so that you have an easier time building on Azure.<\/p>\n Another key feature of a cloud-native database is how well it integrates with the rest of the cloud. Prior to today, if you had data in Azure Blob Storage<\/a>, you\u2019d need to download that data to another VM and then upload it to your database. This introduced unnecessary friction when you were building your application.<\/p>\n Starting now, you can directly interface with Azure Blob Storage through a brand-new PostgreSQL extension, pg_azure_storage<\/a>. After connecting to your PostgreSQL database, you just need to run the following commands:<\/p>\n With pg_azure_storage, you can also make modifications as you\u2019re ingesting data from Azure Blob Storage using user-defined functions. For a detailed list of all features, you can refer to our documentation here<\/a>.<\/p>\n With these cloud-native capabilities, you can build your application with ease. And better yet, you can build your applications ready for running at any scale.<\/span><\/span><\/span>\u00a0<\/span><\/span><\/span>For this, <\/span>our service<\/span> for PostgreSQL <\/span>has <\/span>the<\/span> <\/span>Citus extension<\/span><\/span><\/a> built-in <\/span>and <\/span>allows you to <\/span>scale-out<\/span> your database<\/span> without limitations.<\/span><\/span> Packaged as a fully <\/span>open-source<\/span> extension, <\/span>Citus<\/span> extends PostgreSQL with the power of distributed tables, enabling distributed query execution and\u00a0<\/span><\/span><\/span>performance at scale. <\/span><\/span><\/span>Citus<\/span><\/a> does this while preserving true PostgreSQL at its core, with support for JSONB, geospatial, rich indexing, relational semantics, and more.<\/span><\/span><\/span><\/p>\n With our service for PostgreSQL, you can start building your apps on a single node server group, the same way you would with PostgreSQL. As your app\u2019s scalability and performance requirements grow, you can enable distributed tables and seamlessly scale to multiple nodes.<\/p>\n Azure Cosmos DB makes this transition \u2013 enabling distributed tables \u2013 easy. Previously, if you wanted to use the Citus extension to create a distributed table, you\u2019d first have to pick a sharding key. You\u2019d then have to run a command that would block write operations. With Citus 11.1<\/a>, creating a distributed table and many previously write blocking operations, become fully online.<\/p>\n If you want to see how this online operation works, you\u2019ll love this 1-minute video<\/strong>.<\/p>\n<\/a>Your cloud-native database<\/span><\/h2>\n
\n
<\/a>Azure cloud integrations<\/span><\/h2>\n
SELECT create_extension('azure_storage');\r\nSELECT azure_storage.account_add('mystorageaccount', 'SECRET_ACCESS_KEY');\r\n\r\nCREATE TABLE github_events\r\n(\r\n event_id bigint,\r\n event_type text,\r\n event_public boolean,\r\n repo_id bigint,\r\n payload jsonb,\r\n repo jsonb,\r\n user_id bigint,\r\n org jsonb,\r\n created_at timestamp\r\n);\r\n\r\nCOPY github_events FROM 'https:\/\/mystorageaccount.blob.core.windows.net\/data\/github_events.csv' WITH (format 'csv');<\/pre>\nPostgres with the power of distributed tables<\/span><\/h2>\n