postgresql
27 TopicsAugust 2023 Recap: Azure Database for PostgreSQL Flexible Server
Absolutely thrilled to unveil our latest blog post, " 𝗔𝘂𝗴𝘂𝘀𝘁 𝟮𝟬𝟮𝟯 𝗥𝗲𝗰𝗮𝗽: 𝗔𝘇𝘂𝗿𝗲 𝗗𝗮𝘁𝗮𝗯𝗮𝘀𝗲 𝗳𝗼𝗿 𝗣𝗼𝘀𝘁𝗴𝗿𝗲𝗦𝗤𝗟 𝗙𝗹𝗲𝘅𝗶𝗯𝗹𝗲 𝗦𝗲𝗿𝘃𝗲𝗿 ". This month is jam-packed with feature updates designed to amplify your experience! 1. 𝗔𝘂𝘁𝗼𝘃𝗮𝗰𝘂𝘂𝗺 𝗠𝗼𝗻𝗶𝘁𝗼𝗿𝗶𝗻𝗴 - Elevate your database health with improved tools and metrics. 2. 𝗙𝗹𝗲𝘅𝗶𝗯𝗹𝗲 𝗗𝗡𝗦 𝗭𝗼𝗻𝗲 𝗟𝗶𝗻𝗸𝗶𝗻𝗴 - Simplify your server setup process for multiple networking models. 3. 𝗦𝗲𝗿𝘃𝗲𝗿 𝗣𝗮𝗿𝗮𝗺𝗲𝘁𝗲𝗿 𝗩𝗶𝘀𝗶𝗯𝗶𝗹𝗶𝘁𝘆 𝗲𝗻𝗵𝗮𝗻𝗰𝗲𝗺𝗲𝗻𝘁𝘀 - Now view hidden parameters for better performance optimization. 4. 𝗦𝗶𝗻𝗴𝗹𝗲 𝘁𝗼 𝗙𝗹𝗲𝘅𝗶𝗯𝗹𝗲 𝗦𝗲𝗿𝘃𝗲𝗿 𝗠𝗶𝗴𝗿𝗮𝘁𝗶𝗼𝗻 𝗧𝗼𝗼𝗹𝗶𝗻𝗴 – Simplified migration experience with automated extension allow listing. Don't miss out! Read the full scoop here: August 2023 Recap: Azure Database for PostgreSQL Flexible ServerAutoscaling with Azure: A Comprehensive Guide to PostgreSQL Optimization Using Azure Automation Task
Autoscaling Azure PostgreSQL Server with Automation Tasks Read our latest article detailing the power of Autoscaling the Azure Database for PostgreSQL Flexible Server using Azure Automation Tasks. This new feature can revolutionize how we manage resources, streamlining operations, and minimizing human error.June 2023 Update: Azure Database for PostgreSQL Flexible Server Unveils New Features
The Azure Database for PostgreSQL Flexible Server's June 2023 update is live! Now enjoy: Easier major version upgrades with reduced downtime. Server recovery feature for dropped servers. A more user-friendly Connect experience. Improved server performance with new IO enhancements. Auto-growing storage and online disk resize, now in public preview. We also support minor versions PostgreSQL 15.2 (preview), 14.7, 13.10, 12.14, 11.19. Big thanks to our dedicated team! Check out our blog for more details: https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/june-2023-recap-azure-database-postgresql-flexible-server/ba-p/3868650November 2023 Recap: Azure PostgreSQL Flexible Server
Excited to share our November 2023 updates for Azure Database for PostgreSQL Flexible Server Server Logs management has been streamlined for better monitoring and troubleshooting, along with customizable retention periods. Embracing the latest in security, we now support TLS Version 1.3, ensuring the most secure and efficient client-server communications. Migrations are smoother with our new Pre-Migration Validation feature, making your transition to Flexible Server seamless. Microsoft Defender integration, providing proactive anomaly detection and real-time alerts to safeguard your databases. Additionally, we've upgraded user and role migration capabilities for a more accurate and hassle-free experience. 👥 Link - https://lnkd.in/gMMGaiAK Stay tuned for more updates, and feel free to share your experiences with these new features!PostgreSQL 17 Preview on Azure Postgres Flexible Server
We recently announced the 𝗽𝗿𝗲𝘃𝗶𝗲𝘄 𝗼𝗳 𝗣𝗼𝘀𝘁𝗴𝗿𝗲𝗦𝗤𝗟 𝟭𝟳 on Azure Database for PostgreSQL - 𝗙𝗹𝗲𝘅𝗶𝗯𝗹𝗲 𝗦𝗲𝗿𝘃𝗲𝗿! This release brings exciting new features like improved query performance, dynamic logical replication, enhanced JSON functions, and more—all backed by Azure’s reliable managed services. Try out the preview now and share your feedback! For details, read the complete blog post👉 https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/postgresql-17-preview-on-azure-postgres-flexible-server/bc-p/4263877#M474 We’d love to hear your thoughts—feel free to share feedback or questions in the comments! #PostgreSQL #AzurePostgres #PGConfNYC #Database #OpenSourceNeed feedback on blog post "What's new with Postgres at Microsoft, 2024 edition"
Just published this brand new deep-dive of a blog post to share highlights of all the Azure & the open source work done by the Postgres team at Microsoft over the last 8 months. The title: What's new with Postgres at Microsoft, 2024 edition. // And would like to know: do you find this useful?? The post contains a detailed infographic (handmade) that gives you a visual outline of all the different Postgres workstreams our engineering & PM teams have been driving. And because the Postgres 17 code freeze just happened last month, I included highlights from some of the new PG17 capabilities our Postgres contributor team worked on as well. If you're an Azure Database for PostgreSQL - Flexible Server customer, you won't be disappointed. Lots of new features rolled out in the last 8 months.About "What's new with Postgres at Microsoft", the August 2023 edition
Microsoft is investing a lot in Postgres & this "What's new with Postgres at Microsoft" post walks you through the last 12 months, including new features in Azure Database for PostgreSQL Flexible Server, and Azure Cosmos DB for PostgreSQL—plus our contributions to Postgres core, the Citus database extension, Patroni, PgBouncer, pgcopydb, pg_cron, and more.May 2024 Recap: Azure PostgreSQL Flexible Server
May 2024 Recap: Azure PostgreSQL Flexible Server New Updates for Azure Database for PostgreSQL Flexible Server (May 2024 Recap) 𝗦𝘂𝗽𝗲𝗿𝗰𝗵𝗮𝗿𝗴𝗲 𝗔𝗜 𝗜𝗻𝘁𝗲𝗴𝗿𝗮𝘁𝗶𝗼𝗻 - Seamlessly connect Azure AI services directly in your database (azure_ai extension - GA). 𝗨𝗹𝘁𝗿𝗮-𝗟𝗼𝘄 𝗟𝗮𝘁𝗲𝗻𝗰𝘆 𝗔𝗜 - Generate text embeddings directly within your database for enhanced security (azure_local_ai extension - Preview). 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗲 𝗳𝗼𝗿 𝗣𝗲𝗮𝗸 𝗣𝗲𝗿𝗳𝗼𝗿𝗺𝗮𝗻𝗰𝗲 - Let Azure optimize your database indexes for you (Automated Index Tuning - Preview). 𝗗𝘆𝗻𝗮𝗺𝗶𝗰 𝗜𝗢𝗣𝗦 𝗦𝗰𝗮𝗹𝗶𝗻𝗴 - Pay only for the performance you need (IOPS Scaling - GA). 𝗜𝗺𝗽𝗿𝗼𝘃𝗲𝗱 𝗗𝗮𝘁𝗮 𝗧𝗿𝗮𝗻𝘀𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻 - The CAST function now supports even more complex data manipulation. 𝗦𝗺𝗮𝗿𝘁𝗲𝗿 𝗗𝗮𝘁𝗮𝗯𝗮𝘀𝗲 𝗠𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁 - Get personalized recommendations from Azure Advisor. Check out our new May 2024 Recap blog post for all the details and see how these changes can help you. We’d love to hear your thoughts—feel free to share feedback or questions in the comments!March 2024 Recap: Azure PostgreSQL Flexible Server
Azure Database for PostgreSQL - Flexible Server March'24 Feature Recap 𝗠𝗶𝗴𝗿𝗮𝘁𝗶𝗼𝗻 𝗠𝗮𝗱𝗲 𝗘𝗮𝘀𝘆: Seamlessly transfer PostgreSQL instances with Migration Service (GA). 𝗟𝗮𝘁𝗲𝘀𝘁 𝗣𝗼𝘀𝘁𝗴𝗿𝗲𝘀 𝗠𝗶𝗻𝗼𝗿 𝗩𝗲𝗿𝘀𝗶𝗼𝗻𝘀: Automatically updated to include Postgres versions 16.2, 15.6, 14.11, 13.14, and 12.18. 𝗣𝗼𝘀𝘁𝗴𝗿𝗲𝘀 𝟭𝟲 𝗠𝗮𝗷𝗼𝗿 𝗩𝗲𝗿𝘀𝗶𝗼𝗻 𝗨𝗽𝗴𝗿𝗮𝗱𝗲: Test drive the newest features of PostgreSQL 16 with minimal disruption. 𝗔𝗜 𝗣𝗿𝗲𝗱𝗶𝗰𝘁𝗶𝗼𝗻𝘀 𝗶𝗻 𝗥𝗲𝗮𝗹-𝗧𝗶𝗺𝗲: Integrate machine learning predictions directly within your database with Azure_AI. 𝗡𝗲𝘄 𝗠𝗼𝗻𝗶𝘁𝗼𝗿𝗶𝗻𝗴 𝗠𝗲𝘁𝗿𝗶𝗰: Monitor 'Database Size' for precise capacity planning and performance optimization. Team Microsoft delivered impactful sessions and engaged with the community in Bengaluru @ PGConf India. Check out our blog for a full rundown of March's updates and how they can empower your projects - https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/march-2024-recap-azure-postgresql-flexible-server/ba-p/4107275