Latest updates to Azure Database for PostgreSQL

12

Jul

Latest updates to Azure Database for PostgreSQL

Latest updates to Azure Database for PostgreSQL
https://azure.microsoft.com/blog/latest-updates-to-azure-database-for-postgresql/

Earlier this year, in March, we announced the general availability (GA) of Azure Database for PostgreSQL, offering the community version of MySQL together with built-in high availability, a 99.99 percent availability SLA, elastic scaling for performance, and industry leading security and compliance in Azure. Since GA, the team has been at work delivering a variety of new features and additional functionality to enhance and extend the value of  this service. I am pleased to share with you some details new additions to this service based on customer feedback.

Enhanced security with virtual network service endpoints support in preview

The virtual network service endpoints feature for Azure Database for PostgreSQL is now available in Public Preview for all regions in which the service is available.

Use virtual network service endpoints to isolate connectivity to a logical server from only a subnet or a set of subnets within a virtual network. The traffic to Azure Database for PostgreSQL from your virtual network always stays within the Azure backbone network, preferring this direct route over any specific routes that take internet traffic through virtual appliances or on-premises. There’s no additional billing for virtual network access through service endpoints. Learn more about virtual network service endpoints and how to configure them.

Support for large databases and increased IOPS

Customers can now create 4 TB servers or update existing server storage to 4 TB in Azure Database for PostgreSQL when they select the General Purpose or Memory Optimized service tiers.  With increased storage, customers also leverage up to 6000 IOPS.

Disaster recovery across regions made easier with geo redundant backups and recovery

Geo Restore is now generally available. Azure Database for PostgreSQL servers are backed up periodically to enable Restore features. Using this feature, you may restore the server and all its databases to an earlier point-in-time, on a new server, making disaster recovery across regions even easier.

Support for PostgreSQL version 10.3

The latest update to PostgreSQL version 10, version 10.3, is now generally available in Azure Database for PostgreSQL. Features in this version include improved query parallelism and declarative table partitioning. To start using this version, create a new Azure Database for PostgreSQL server, and then select version 10.

Migration support with Azure Database Migration Service (DMS) preview

Customers can now migrate PostgreSQL databases to Azure Database for PostgreSQL with minimal downtime by using the Azure Database Migration Service (DMS). Use the Azure CLI to provision an instance of DMS to perform migrations from PostgreSQL on-premises or on virtual machines to Azure Database for PostgreSQL.

Memory optimized pricing tier generally available

Customers can now create and switch to the new memory optimized pricing tier, which is designed for high-performance database workloads that require in-memory performance for faster transaction processing and higher concurrency.

With boundary scaling now available, customers can also scale across SKUs (General Purpose and Memory Optimized).

Regional availability increased to 28 countries/regions worldwide

General availability of Azure Database MySQL has been extended to the following countries/regions: Central US (Gen 4), North Central US (Gen 5), France Central (Gen 5), East Asia (Gen 5), Australia East (Gen5), Australia East 2 (Gen5), Australia Southeast (Gen 5), Central India (Gen 5), West India (Gen 5), South India (Gen 5), and Korea Central (Gen 5).

Also, in addition to previously available Gen 4 compute, Gen 5 compute is now generally available in the following regions: Brazil South, East US 2, Japan East, Japan West, South Central US, and Southeast Asia.

For a complete list of the 28 available countries/regions, see the article Azure Database for PostgreSQL pricing tiers.

Additional resources for Azure Database for PostgreSQL

If you are currently this database service, you might find the following links useful:

I hope that you enjoy working with the latest features and functionality available in our Azure Database for PostgreSQL. Be sure to share your impressions via User Voice for PostgreSQL or @Ask Azure DB for PostgreSQL.