{"id":15558,"date":"2019-03-04T11:27:44","date_gmt":"2019-03-04T05:57:44","guid":{"rendered":"https:\/\/mobisoftinfotech.com\/resources\/?p=15558"},"modified":"2025-05-26T18:20:19","modified_gmt":"2025-05-26T12:50:19","slug":"important-gotchas-about-azure-database-for-postgresql","status":"publish","type":"post","link":"https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql","title":{"rendered":"Important Gotchas and Limitations About Azure Database for PostgreSQL"},"content":{"rendered":"<p>Azure Database for PostgreSQL (called Azure PG, henceforth) is a fully managed service provided by Microsoft. Azure PG provides features like push-button scalability, high availability, automated geo distributed backups, encryption at rest,  point in time restore (PITR) which makes it highly desirable if you use PostgreSQL and Azure is your platform of choice. It&#8217;s a competing service for Amazon RDS for PostgreSQL. <\/p>\n\n\n\n<p>However, like any other decision in computing, there are certain tradeoffs that one needs to be aware of while choosing a service. Here are certain gotchas and limitations you should be aware of while choosing Azure PG.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Automatic major version upgrade is not supported.<\/li>\n<\/ul>\n\n\n\n<p>Azure PG supports automatic upgrades for minor version patches. However, upgrading from a major version like PostgreSQL 9.5 to PostgreSQL 9.6 is not supported. <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Major versions supported. <\/li>\n<\/ul>\n\n\n\n<p>As of Feb. 2019, only PostgreSQL versions 9.5, 9.6 and 10 are supported with Azure PG. PostgreSQL 11 support is noticeably missing. PG 11 is available on Amazon RDS. <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You can change the storage and backup retention period without any downtime, but you can&#8217;t change the backup type once the server is created. You can choose between locally redundant and geo-redundant backups. <\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The storage can only be increased. <\/li>\n<\/ul>\n\n\n\n<ul><li>When restoring a server using PITR, the new server created doesn&#8217;t have the firewall rules which were added to the original server. You will need to add these again. You might also need to recreate the database level logins and permissions.<\/li><li>Once you reach the 95% limit of the allocated storage, the server shifts to read-only mode.<span style=\"background-color: rgb(232, 234, 235);\"><\/span><\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You can not upgrade to General Purpose or Memory Optimized instance types from Basic instance type. Basic instance is limited to max 2 vCores and 4GB of RAM. <\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Maximum storage size for Basic instance type is 1 TB. Maximum storage for General Purpose and Memory Optimized instances is 4 TB.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>VNet is supported for only  General Purpose or Memory Optimized instances.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>When you change the number of vCores, instance type or pricing tier, a copy of the existing server is created with new capacity. Then connections are switched over to the new instance. There can be a service disruption of up to a minute during this switchover. <\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You can configure up to 5 read replicas in same Azure region for a master Azure PG database. <\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You can disconnect a read replica from the master DB. Once disconnected the read replica becomes a standalone DB. Once converted to standalone DB it can be converted to a read replica again. <\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>When a master DB server is deleted, all of its replicas become standalone servers. <\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/mobisoftinfotech.com\/services\/devops?utm_source=blog&amp;utm_medium=important-gotchas-about-azure-database-for-postgresql-cta1  \"><noscript><img decoding=\"async\" width=\"855\" height=\"363\" src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2025\/05\/Unlock-10x-Faster-Deployments-with-DevOps-Automation.png\" alt class=\"wp-image-38914\"><\/noscript><img decoding=\"async\" width=\"855\" height=\"363\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20855%20363%22%3E%3C%2Fsvg%3E\" alt class=\"wp-image-38914 lazyload\" data-src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2025\/05\/Unlock-10x-Faster-Deployments-with-DevOps-Automation.png\"><\/a><\/figure>\n\n\n\n<p>Despite all of these limitations, Azure PgSQL is a very good service. All managed DB services have limitations on one type or another. As a cloud specialist, it&#8217;s very important to know these limitations beforehand so as to ensure that a production deployment doesn&#8217;t run into one of these unexpected. <\/p>\n\n\n\n<p>At Mobisoft, we ensure that our <a href=\"https:\/\/mobisoftinfotech.com\/services\/cloud-development\">Cloud Developers<\/a> are aware of such nuances for each of the cloud platforms we use. Are you in need of such Cloud Experts? Please <a href=\"https:\/\/mobisoftinfotech.com\/contact-us\">get in touch<\/a> and we will be happy to guide you!<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/mobisoftinfotech.com\/contact-us?utm_source=blog&amp;utm_medium=referral&amp;utm_campaign=important-gotchas-about-azure-database-for-postgresql-cta2\"><noscript><img decoding=\"async\" width=\"855\" height=\"363\" src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2025\/03\/your-next-big-idea-needs-the-right-tech.png\" alt class=\"wp-image-36434\"><\/noscript><img decoding=\"async\" width=\"855\" height=\"363\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20855%20363%22%3E%3C%2Fsvg%3E\" alt class=\"wp-image-36434 lazyload\" data-src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2025\/03\/your-next-big-idea-needs-the-right-tech.png\"><\/a><\/figure>\n\n\n\n<div class=\"modern-author-card\">\n    <div class=\"author-card-content\">\n        <div class=\"author-info-section\">\n            <div class=\"author-avatar\">\n                <noscript><img decoding=\"async\" src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2022\/04\/Pritam1.jpg\" alt=\"Pritam Barhate\"><\/noscript><img decoding=\"async\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" alt=\"Pritam Barhate\" data-src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2022\/04\/Pritam1.jpg\" class=\" lazyload\">\n            <\/div>\n            <div class=\"author-details\">\n                <h3 class=\"author-name\">Pritam Barhate<\/h3>\n                <p class=\"author-title\">Head of Technology Innovation<\/p>\n                <a href=\"javascript:void(0);\" class=\"read-more-link read-more-btn\" onclick=\"toggleAuthorBio(this); return false;\">Read more <noscript><img decoding=\"async\" src=\"\/assets\/images\/blog\/Vector.png\" alt=\"expand\" class=\"read-more-arrow down-arrow\"><\/noscript><img decoding=\"async\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" alt=\"expand\" class=\"read-more-arrow down-arrow lazyload\" data-src=\"\/assets\/images\/blog\/Vector.png\"><\/a>\n                <div class=\"author-bio-expanded\">\n                    <p>Pritam Barhate, with an experience of 14+ years in technology, heads Technology Innovation at <a href=\"https:\/\/mobisoftinfotech.com\" target=\"_blank\" rel=\"noopener\">Mobisoft Infotech<\/a>. He has a rich experience in design and development. He has been a consultant for a variety of industries and startups. At Mobisoft Infotech, he primarily focuses on technology resources and develops the most advanced solutions.<\/p>\n                    <div class=\"author-social-links\">\n                        <div class=\"social-icon\">\n                            <a href=\"https:\/\/www.linkedin.com\/in\/pritam-barhate-90b93414\/\" target=\"_blank\" rel=\"nofollow noopener\"><i class=\"icon-sprite linkedin\"><\/i><\/a>\n                            <a href=\"https:\/\/twitter.com\/pritambarhate\" target=\"_blank\" rel=\"nofollow noopener\"><i class=\"icon-sprite twitter\"><\/i><\/a>\n                        <\/div>\n                    <\/div>\n                    <a href=\"javascript:void(0);\" class=\"read-more-link read-less-btn\" onclick=\"toggleAuthorBio(this); return false;\" style=\"display: none;\">Read less <noscript><img decoding=\"async\" src=\"\/assets\/images\/blog\/Vector.png\" alt=\"collapse\" class=\"read-more-arrow up-arrow\"><\/noscript><img decoding=\"async\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" alt=\"collapse\" class=\"read-more-arrow up-arrow lazyload\" data-src=\"\/assets\/images\/blog\/Vector.png\"><\/a>\n                <\/div>\n            <\/div>\n        <\/div>\n        <div class=\"share-section\">\n            <span class=\"share-label\">Share Article<\/span>\n            <div class=\"social-share-buttons\">\n                <a href=\"https:\/\/www.facebook.com\/sharer\/sharer.php?u=https%3A%2F%2Fmobisoftinfotech.com%2Fresources%2Fblog%2Fimportant-gotchas-about-azure-database-for-postgresql\" target=\"_blank\" class=\"share-btn facebook-share\"><i class=\"fa fa-facebook-f\"><\/i><\/a>\n                <a href=\"https:\/\/www.linkedin.com\/sharing\/share-offsite\/?url=https%3A%2F%2Fmobisoftinfotech.com%2Fresources%2Fblog%2Fimportant-gotchas-about-azure-database-for-postgresql\" target=\"_blank\" class=\"share-btn linkedin-share\"><i class=\"fa fa-linkedin\"><\/i><\/a>\n            <\/div>\n        <\/div>\n    <\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Azure Database for PostgreSQL (called Azure PG, henceforth) is a fully managed service provided by Microsoft. Azure PG provides features like push-button scalability, high availability, automated geo distributed backups, encryption at rest, point in time restore (PITR) which makes it highly desirable if you use PostgreSQL and Azure is your platform of choice. It&#8217;s a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":15564,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_s2mail":"","footnotes":""},"categories":[286],"tags":[1006,657,993],"class_list":["post-15558","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-azure-database-for-postgresql","tag-cloud-computing","tag-technical-guide"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Important Gotchas and Limitations About Azure Database for PostgreSQL<\/title>\n<meta name=\"description\" content=\"All managed DB services have limitations including Azure database for PostgreSQL. As a cloud specialist, it&#039;s important to know these limitations beforehand.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Important Gotchas and Limitations About Azure Database for PostgreSQL\" \/>\n<meta property=\"og:description\" content=\"All managed DB services have limitations including Azure database for PostgreSQL. As a cloud specialist, it&#039;s important to know these limitations beforehand.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql\" \/>\n<meta property=\"og:site_name\" content=\"Mobisoft Infotech\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-04T05:57:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-26T12:50:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2019\/03\/azure-database-banner.png\" \/>\n\t<meta property=\"og:image:width\" content=\"855\" \/>\n\t<meta property=\"og:image:height\" content=\"392\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Pritam Barhate\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Pritam Barhate\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql#article\",\"isPartOf\":{\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql\"},\"author\":{\"name\":\"Pritam Barhate\",\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/#\/schema\/person\/fa762036b3364f26abeea146c01487ee\"},\"headline\":\"Important Gotchas and Limitations About Azure Database for PostgreSQL\",\"datePublished\":\"2019-03-04T05:57:44+00:00\",\"dateModified\":\"2025-05-26T12:50:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql\"},\"wordCount\":523,\"image\":{\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql#primaryimage\"},\"thumbnailUrl\":\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2019\/03\/azure-database-banner.png\",\"keywords\":[\"azure database for PostgreSQL\",\"Cloud Computing\",\"technical guide\"],\"articleSection\":[\"Blog\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql\",\"url\":\"https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql\",\"name\":\"Important Gotchas and Limitations About Azure Database for PostgreSQL\",\"isPartOf\":{\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql#primaryimage\"},\"image\":{\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql#primaryimage\"},\"thumbnailUrl\":\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2019\/03\/azure-database-banner.png\",\"datePublished\":\"2019-03-04T05:57:44+00:00\",\"dateModified\":\"2025-05-26T12:50:19+00:00\",\"author\":{\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/#\/schema\/person\/fa762036b3364f26abeea146c01487ee\"},\"description\":\"All managed DB services have limitations including Azure database for PostgreSQL. As a cloud specialist, it's important to know these limitations beforehand.\",\"breadcrumb\":{\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql#primaryimage\",\"url\":\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2019\/03\/azure-database-banner.png\",\"contentUrl\":\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2019\/03\/azure-database-banner.png\",\"width\":855,\"height\":392,\"caption\":\"Azure Database for PostgreSQL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/mobisoftinfotech.com\/resources\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Important Gotchas and Limitations About Azure Database for PostgreSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/#website\",\"url\":\"https:\/\/mobisoftinfotech.com\/resources\/\",\"name\":\"Mobisoft Infotech\",\"description\":\"Discover Mobility\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/mobisoftinfotech.com\/resources\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/#\/schema\/person\/fa762036b3364f26abeea146c01487ee\",\"name\":\"Pritam Barhate\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/0e481c7ce54b3567ac70ddfc493523eefce0bdc3ee69fd2654f8f60a79e2f178?s=96&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0e481c7ce54b3567ac70ddfc493523eefce0bdc3ee69fd2654f8f60a79e2f178?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0e481c7ce54b3567ac70ddfc493523eefce0bdc3ee69fd2654f8f60a79e2f178?s=96&r=g\",\"caption\":\"Pritam Barhate\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Important Gotchas and Limitations About Azure Database for PostgreSQL","description":"All managed DB services have limitations including Azure database for PostgreSQL. As a cloud specialist, it's important to know these limitations beforehand.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql","og_locale":"en_US","og_type":"article","og_title":"Important Gotchas and Limitations About Azure Database for PostgreSQL","og_description":"All managed DB services have limitations including Azure database for PostgreSQL. As a cloud specialist, it's important to know these limitations beforehand.","og_url":"https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql","og_site_name":"Mobisoft Infotech","article_published_time":"2019-03-04T05:57:44+00:00","article_modified_time":"2025-05-26T12:50:19+00:00","og_image":[{"width":855,"height":392,"url":"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2019\/03\/azure-database-banner.png","type":"image\/png"}],"author":"Pritam Barhate","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Pritam Barhate","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql#article","isPartOf":{"@id":"https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql"},"author":{"name":"Pritam Barhate","@id":"https:\/\/mobisoftinfotech.com\/resources\/#\/schema\/person\/fa762036b3364f26abeea146c01487ee"},"headline":"Important Gotchas and Limitations About Azure Database for PostgreSQL","datePublished":"2019-03-04T05:57:44+00:00","dateModified":"2025-05-26T12:50:19+00:00","mainEntityOfPage":{"@id":"https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql"},"wordCount":523,"image":{"@id":"https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql#primaryimage"},"thumbnailUrl":"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2019\/03\/azure-database-banner.png","keywords":["azure database for PostgreSQL","Cloud Computing","technical guide"],"articleSection":["Blog"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql","url":"https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql","name":"Important Gotchas and Limitations About Azure Database for PostgreSQL","isPartOf":{"@id":"https:\/\/mobisoftinfotech.com\/resources\/#website"},"primaryImageOfPage":{"@id":"https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql#primaryimage"},"image":{"@id":"https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql#primaryimage"},"thumbnailUrl":"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2019\/03\/azure-database-banner.png","datePublished":"2019-03-04T05:57:44+00:00","dateModified":"2025-05-26T12:50:19+00:00","author":{"@id":"https:\/\/mobisoftinfotech.com\/resources\/#\/schema\/person\/fa762036b3364f26abeea146c01487ee"},"description":"All managed DB services have limitations including Azure database for PostgreSQL. As a cloud specialist, it's important to know these limitations beforehand.","breadcrumb":{"@id":"https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql#primaryimage","url":"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2019\/03\/azure-database-banner.png","contentUrl":"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2019\/03\/azure-database-banner.png","width":855,"height":392,"caption":"Azure Database for PostgreSQL"},{"@type":"BreadcrumbList","@id":"https:\/\/mobisoftinfotech.com\/resources\/blog\/important-gotchas-about-azure-database-for-postgresql#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/mobisoftinfotech.com\/resources\/"},{"@type":"ListItem","position":2,"name":"Important Gotchas and Limitations About Azure Database for PostgreSQL"}]},{"@type":"WebSite","@id":"https:\/\/mobisoftinfotech.com\/resources\/#website","url":"https:\/\/mobisoftinfotech.com\/resources\/","name":"Mobisoft Infotech","description":"Discover Mobility","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/mobisoftinfotech.com\/resources\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/mobisoftinfotech.com\/resources\/#\/schema\/person\/fa762036b3364f26abeea146c01487ee","name":"Pritam Barhate","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0e481c7ce54b3567ac70ddfc493523eefce0bdc3ee69fd2654f8f60a79e2f178?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0e481c7ce54b3567ac70ddfc493523eefce0bdc3ee69fd2654f8f60a79e2f178?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0e481c7ce54b3567ac70ddfc493523eefce0bdc3ee69fd2654f8f60a79e2f178?s=96&r=g","caption":"Pritam Barhate"}}]}},"_links":{"self":[{"href":"https:\/\/mobisoftinfotech.com\/resources\/wp-json\/wp\/v2\/posts\/15558","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mobisoftinfotech.com\/resources\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mobisoftinfotech.com\/resources\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mobisoftinfotech.com\/resources\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mobisoftinfotech.com\/resources\/wp-json\/wp\/v2\/comments?post=15558"}],"version-history":[{"count":11,"href":"https:\/\/mobisoftinfotech.com\/resources\/wp-json\/wp\/v2\/posts\/15558\/revisions"}],"predecessor-version":[{"id":38916,"href":"https:\/\/mobisoftinfotech.com\/resources\/wp-json\/wp\/v2\/posts\/15558\/revisions\/38916"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mobisoftinfotech.com\/resources\/wp-json\/wp\/v2\/media\/15564"}],"wp:attachment":[{"href":"https:\/\/mobisoftinfotech.com\/resources\/wp-json\/wp\/v2\/media?parent=15558"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mobisoftinfotech.com\/resources\/wp-json\/wp\/v2\/categories?post=15558"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mobisoftinfotech.com\/resources\/wp-json\/wp\/v2\/tags?post=15558"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}