Aug 2024 Recap: Azure PostgreSQL Flexible Server
Hello Azure Community,
This August, our Azure Database for PostgreSQL Flexible Server received some great updates that make it even better and simpler to use. We’ve introduced new security features, enhanced monitoring capabilities, and made improvements to how you can set up and manage your databases. Here’s a quick look at what’s new this month:
Feature Highlights
Reserved pricing availability for Intel & AMD V5 SKUs
Support latest Postgres minor versions
Support for postgres_protobuf Extension
Support for postgresql_anonymizer (anon) Extension
Ansible module update
DNS Record Updates with Private Endpoint Changes
Support for TimescaleDB extension in migration service
Support for migration into Flexible server’s Burstable SKU
LangChain Docs Enhancements
Reserved Pricing Availability for Intel & AMD V5 SKUs
We’re pleased to announce that reservations for V5 SKUs (Intel & AMD) are now available on Azure Database for PostgreSQL Flexible Server. By reserving compute resources in advance, you can enjoy significant savings over pay-as-you-go pricing options. Commit to either a one-year or three-year plan to receive up to 65% off on compute costs. Check the Reservation pane on the Azure portal to see how much you could save based on different pricing tiers and regions. Reserved instances help you predict and manage your budget more effectively.
For more details, please refer to the Reserved Pricing documentation for Azure Database for PostgreSQL Flexible Server.
Support latest Postgres minor versions
Azure Database for PostgreSQL Flexible Server now supports newer minor versions: 16.4, 15.8, 14.13, 13.16, and 12.20. These updates, performed automatically during scheduled maintenance, ensure that your database runs on the most secure and efficient version available. This round of updates includes critical security patches and over 55 bug fixes.
For additional information, check out the PostgreSQL community announcement about the new minor versions.
Support for postgres_protobuf extension
The latest version (0.3.1) of the `postgres_protobuf` extension is now available. This extension is designed to convert protobuf columns to and from JSON, enhancing the flexibility of data usage within your databases. It’s an open-source tool that broadens your database’s capabilities.
Learn more about this and other extensions on the Extensions documentation page.
Support for postgresql_anonymizer (anon) extension
The `postgresql_anonymizer` extension, also known as the anon extension, is now available in version 1.3.2. This tool helps mask or anonymize sensitive data directly within your database, providing an extra layer of data protection.
To explore this extension further, visit the PostgreSQL Anonymizer documentation.
Ansible Module Update
The Ansible Galaxy azure_rm_postgresqlflexiblerserver module is now updated to support deploying PostgreSQL major versions up to 16. This expansion from previously supported versions up to 13 allows more flexibility in managing your database environments using automation tools.
For more information, please visit the Ansible azure.azcollection module documentation.
DNS Record Updates with Private Endpoint Changes
Whenever a private endpoint configuration is updated on Azure Database for PostgreSQL Flexible Server, the DNS records are now automatically adjusted to reflect these changes. This ensures that your connectivity settings are always synchronized with your network configurations.
For detailed information, refer to the Flexible Server with Private Link documentation.
Support for TimescaleDB extension in migration service
The PostgreSQL migration service now supports the migration of databases using the TimescaleDB extension without needing to convert time series tables to regular tables. This update facilitates the direct migration of specialized time series data.
For a detailed guide on this feature, please check out the migration service tutorials.
Support for migration into Flexible Server’s Burstable SKU
You can now directly migrate your workloads into the Flexible Server’s Burstable SKU, currently in preview in West Europe and soon to be available globally. This feature is ideal for workloads that require flexible performance scaling.
Learn more about this capability in the Burstable SKU documentation.
LangChain Docs Enhancement
Building GenAI apps with Azure Database for Postgres and LangChain has never been easier! We’ve updated the LangChain docs to include how users can use Azure Database for PostgreSQL as a vector store for their GenAI application.
Learn more about this here: Microsoft | LangChain Also take a look at a previous blog about LangChain support for a full end-to-end example.
Conclusion
In closing, the updates this month make Azure Database for PostgreSQL Flexible Server better and more user-friendly. Try out these new features to improve how you manage and secure your databases. We value your feedback and are always looking to make our services better. Keep an eye out for more updates!
Microsoft Tech Community – Latest Blogs –Read More