https://www.infoq.com/news/2022/07/amazon-aurora-postgresql-14/ BT Live Webinar and Q&A: Going Cloud Native with Serverless Data (Live Webinar Aug 18th, 2022) Register Now Close Toggle Navigation Facilitating the Spread of Knowledge and Innovation in Professional Software Development English edition * English edition * Chinese edition * Japanese edition * French edition Write for InfoQ Search [ ] [Search] Sign Up / Login Email [ ] Password [ ] [Login] Forgot password ? InfoQ Account Email [ ] [Send Recovery Email] Back to login Resend Activation [ ] [Resend] Back to login Login with: Google Microsoft Twitter Facebook Don't have an InfoQ account? Sign Up Logo - Back to homepage 2,300,300 Jun unique visitors News Articles Presentations Podcasts Guides Topics Development * Java * Kotlin * .Net * C# * Swift * Go * Rust * JavaScript Featured in Development * Reproducible Development with Containers Avdi Grimm describes the future of development, which is already here. Get a tour of a devcontainer, and contrast it with a deployment container. Reproducible Development with Containers All in development Architecture & Design * Architecture * Enterprise Architecture * Scalability/Performance * Design * Case Studies * Microservices * Service Mesh * Patterns * Security Featured in Architecture & Design * Authorization at Netflix Scale Travis Nelson discusses Netflix's approach to scaling and shares techniques for distributed caching and isolating failure domains. Authorization at Netflix Scale All in architecture-design AI, ML & Data Engineering * Big Data * Machine Learning * NoSQL * Database * Data Analytics * Streaming Featured in AI, ML & Data Engineering * API Friction Complicates Hunting for Cloud Vulnerabilities. SQL Makes it Simple APIs can tell you everything about your cloud infrastructure, but they're hard to use and work in different ways. What if you could write simple SQL queries that call APIs for you and put results into a database? Steampipe, an open-source project that maps APIs to Postgres foreign tables, makes that dream come true. It's hard enough to reason over data. Acquiring it should be easy, and now it is. API Friction Complicates Hunting for Cloud Vulnerabilities. SQL Makes it Simple All in ai-ml-data-eng Culture & Methods * Agile * Diversity * Leadership * Lean/Kanban * Personal Growth * Scrum * Sociocracy * Software Craftmanship * Team Collaboration * Testing * UX Featured in Culture & Methods * Making the DevOps Pipeline Transparent and Governable In this podcast Shane Hastie spoke to David Williams of Quali about DevOps culture, visibility into the pipeline and effective governance. Making the DevOps Pipeline Transparent and Governable All in culture-methods DevOps * Infrastructure * Continuous Delivery * Automation * Containers * Cloud * Observability Featured in DevOps * DevSecOps Best Practices for Identity & Access Management The panelists discuss how to integrate security into DevOps, where their concerns are and how each is addressed. DevSecOps Best Practices for Identity & Access Management All in devops EventsNew Helpful links * About InfoQ * InfoQ Editors * Write for InfoQ * About C4Media * Diversity Choose your language * En * Zhong Wen * Ri Ben * Fr InfoQ Live July InfoQ Live July Learn how to migrate an application to serverless and what are the common mistakes to avoid. Register Now. InfoQ Live August InfoQ Live August Learn how cloud architectures help organizations take care of application and cloud security, observability, availability and elasticity. Register Now. QCon San Francisco QCon San Francisco Understand the emerging software trends you should pay attention to. Attend in-person on Oct 24-28, 2022. QCon Plus QCon Plus Make the right decisions by uncovering how senior software developers at early adopter companies are adopting emerging trends. Register Now. InfoQ Homepage News Amazon Aurora Supports PostgreSQL 14 Cloud Going Cloud Native with Serverless Data (Live Webinar Aug 18th, 2022) - Save Your Seat Amazon Aurora Supports PostgreSQL 14 Like Print Bookmarks Jul 09, 2022 2 min read by * Renato Losio Write for InfoQ Join a community of experts. Increase your visibility. Grow your career.Learn more Amazon recently announced that Aurora PostgreSQL supports PostgreSQL major version 14. The new release adds performance improvements and new capabilities, including support for SCRAM password encryption. PostgreSQL 14 includes improvements for parallel queries, heavily-concurrent workloads, partitioned tables, logical replication, and vacuuming. The 14.3 version adds new capabilities such as the ability to close idle sessions or to cancel long-running queries if a client disconnects. Other benefits of PostgreSQL 14 include multiranges, allowing representation of non-contiguous data ranges, and stored procedures returning data using OUT parameters. The new Aurora release adds support for SCRAM password encryption, an alternative to the default MD5 algorithm for encrypting passwords. SCRAM has been backported to previous Aurora PostgreSQL versions (10, 11, 12, 13) and AWS recommends using SCRAM rather than MD5 for any new cluster. Aurora for PostgreSQL provides continuous backups, up to 15 read replicas, multi-region replication and the option to run in serverless mode. The general availability of the on-demand, auto-scaling configuration was announced last April and is now compatible with PostgreSQL 14. Existing clusters can be upgraded to the PostgreSQL 14 version. Further upgrades of minor versions can be achieved without downtime as the cloud provider has recently released zero-downtime patching (ZDP), a feature to preserve client connections when the database restarts. There were initially some concerns in the community related to the choice of version 14.3, but the cloud provider backported a few of the most recent fixes from 14.4, including the one for the CONCURRENTLY bug. To simplify the release process, the Aurora version is going forward the same as the major.minor version of the PostgreSQL community version, with a third digit in the patch location. Murat Demirbas, principal applied scientist at AWS, recently wrote a popular article on the decoupled architecture of Amazon Aurora. The new release of the high-throughput cloud-native relational database includes new features for Babelfish for Aurora PostgreSQL version 2.1 , the open source capability to run Microsoft SQL Server applications on PostgreSQL. Version 14.3 is the third major version of the managed service since the beginning of 2021: last year Aurora introduced support for PostgreSQL 12 and PostgreSQL 13, as reported by InfoQ, showing a significantly shorter release cycle than for the MySQL versions. Amazon Aurora is not the first managed service with PostgreSQL 14 compatibility: Amazon RDS supports it and other providers have already added support too, including Flexible Server PostgreSQL on Azure and Azure's Hyperscale (Citus). PostgreSQL 14 is available in all regions supported by Aurora. There are no price differences among engine versions. About the Author Renato Losio Show moreShow less Inspired by this content? Write for InfoQ. Becoming an editor for InfoQ was one of the best decisions of my career. It has challenged me and helped me grow in so many ways. We'd love to have more people join our team. [ccccd59] Thomas BettsLead Editor, Software Architecture and Design @InfoQ; Senior Principal Engineer Write for InfoQ Rate this Article Adoption ( ) ( ) ( ) ( ) ( ) Style ( ) ( ) ( ) ( ) ( ) [ ] [Submit] [ ] [Submit] [ ] Author Contacted This content is in the Cloud topic Related Topics: * Development * Architecture & Design * Amazon RDS * Postgres * Relational Databases * Database * Cloud * Related Editorial * Related Sponsored Content * Related Sponsor [MicrosoftL] Microsoft JDConf '22: Cloud Native Java, JVM Configuration, GraalVM, Spring Boot, and More - Watch All Sessions On-Demand. Related Content * PostgreSQL Interface for Cloud Spanner Now Generally Available * API Friction Complicates Hunting for Cloud Vulnerabilities. SQL Makes it Simple API Friction Complicates Hunting for Cloud Vulnerabilities. SQL Makes it Simple * Two Must-Have Tools for Jakarta EE Developers Two Must-Have Tools for Jakarta EE Developers * A Recipe to Migrate and Scale Monoliths in the Cloud A Recipe to Migrate and Scale Monoliths in the Cloud * An Introduction and Tutorial for Azure Cosmos DB An Introduction and Tutorial for Azure Cosmos DB * Google Cloud Launches New Sustainability Offerings for Climate Resiliency * VMware vSphere+ and vSAN+ Promise to Bring the Benefits of the Cloud to On-Premises Workloads * TLS 1.2 Becoming the Minimum TLS Protocol Level on AWS * The Compounding (Business) Value of Composable Ecosystems The Compounding (Business) Value of Composable Ecosystems * Microsoft Limits Public Access to AI-Powered Facial Analysis Features * AWS Releases IoT ExpressLink: Cloud-Connectivity Software for Hardware Modules * SynLapse: Orca Security Publishes Details for Critical Azure Synapse Vulnerability * AWS Mainframe Modernization Service Now Generally Available * Cloud-Native Application Security: Your Attack Surface Just Got Bigger Cloud-Native Application Security: Your Attack Surface Just Got Bigger * Amazon Connect Offers General Availability of Outbound Campaigns for Calls, Texts, and Emails * Google Expands Its Distributed Cloud Platform with Anthos On-Premises * Developing a Cloud-Native Application on Microsoft Azure Using Open Source Technologies Developing a Cloud-Native Application on Microsoft Azure Using Open Source Technologies * Ubuntu Core 22 Brings Real-Time Compute Support for IoT Industrial Applications * DevOps and Cloud InfoQ Trends Report - June 2022 DevOps and Cloud InfoQ Trends Report - June 2022 * Microsoft Launches New Storage Optimized VMs with Lasv3 and Lsv3 * Cockroach Labs 2022 Cloud Report: AMD Outperforms Intel * MongoDB Atlas Serverless Instances and Data API Now Generally Available * Database Command Batching in .NET 6 * Microsoft Launches the Public Preview of Dynatrace for Azure as a SaaS Solution in Their Marketplace * Microsoft Introduces a New Learning Resource with Azure Skills Navigator * How Do We Utilize Chaos Engineering to Become Better Cloud-Native Engineers? How Do We Utilize Chaos Engineering to Become Better Cloud-Native Engineers? * AWS Introduces IP-Based Routing on Route 53 * Full Stack Dart Full Stack Dart * The What and Why of Programmable Proxies The What and Why of Programmable Proxies * Exploring Architectural Concepts Building a Card Game Exploring Architectural Concepts Building a Card Game * Kubernetes Crosses the Chasm, and Other Lessons from the 2021 CNCF Survey Kubernetes Crosses the Chasm, and Other Lessons from the 2021 CNCF Survey * One Ring -3 to Secure Them All: Computing with Hardware Enclaves One Ring -3 to Secure Them All: Computing with Hardware Enclaves * Cloud DevSecOps in Practice: People, Processes and Tools Cloud DevSecOps in Practice: People, Processes and Tools * Data Patterns for the Edge: Data Localization, Privacy Laws, and Performance Data Patterns for the Edge: Data Localization, Privacy Laws, and Performance * Designing IoT Solutions with Microsoft Azure Designing IoT Solutions with Microsoft Azure * InfoQ Mobile and IoT Trends Report 2022 InfoQ Mobile and IoT Trends Report 2022 * Seven Ways to Fail at Microservices Seven Ways to Fail at Microservices * How Do You Distribute Your Database over Hundreds of Edge Locations? How Do You Distribute Your Database over Hundreds of Edge Locations? * Cloud Native Continuous Delivery on Kubernetes with Tekton Cloud Native Continuous Delivery on Kubernetes with Tekton * How to Create a Network Proxy Using Stream Processor Pipy How to Create a Network Proxy Using Stream Processor Pipy The InfoQ Newsletter A round-up of last week's content on InfoQ sent out every Tuesday. Join a community of over 250,000 senior developers. View an example Enter your e-mail address [ ] [ ] Select your country [Select a country] [ ] I consent to InfoQ.com handling my data as explained in this Privacy Notice. [Subscribe] We protect your privacy. Hello stranger! You need to Register an InfoQ account or Login or login to post comments. But there's so much more behind being registered. Get the most out of the InfoQ experience. Tell us what you think [ ] [ ] Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p [ ] Email me replies to any of my messages in this thread [Post Message] Community comments Watch thread Close Your Reply Quote original message [ ] [ ] Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p [ ] Email me replies to any of my messages in this thread [Post Message] Cancel Close Your Reply [ ] [ ] Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p [ ] Email me replies to any of my messages in this thread [Post Message] Cancel Close OK Discuss * Development + Git 2.37 Brings Built-in File Monitor, Improved Pruning, and More + New PACMAN Vulnerability Affecting Apple Silicon CPUs + GitHub Copilot Adopts Paid Model, Still Free for Some Open-Source Maintainers and Students * Architecture & Design + Authorization at Netflix Scale + Using GraphQL and Ballerina with Multiple Data Sources + Trivago's Journey from PHP+Melody to Next.js and Typescript * Culture & Methods + Making the DevOps Pipeline Transparent and Governable + Trust-Driven Development: Accelerate Delivery and Increase Creativity + How to Introduce Innovation into the DNA of 21st Century Companies * AI, ML & Data Engineering + Google's BigQuery Introduces Column-Level Encryption Functions and Dynamic Masking of Information + LinkedIn Open-Sourced Its Feature Store to Evangelize Productive Machine Learning + Amazon Unveils ML-Powered Coding Assistant CodeWhisperer * DevOps + DevSecOps Best Practices for Identity & Access Management + K8s: Rampant Pragmatism in the Cloud at Starling Bank + How Development Teams Can Orchestrate Their Workflow with Pipelines as Code The InfoQ Newsletter A round-up of last week's content on InfoQ sent out every Tuesday. Join a community of over 250,000 senior developers. View an example * Get a quick overview of content published on a variety of innovator and early adopter technologies * Learn what you don't know that you don't know * Stay up to date with the latest information from the topics you are interested in Enter your e-mail address [ ] [ ] Select your country [Select a country] [ ] I consent to InfoQ.com handling my data as explained in this Privacy Notice. [Subscribe] We protect your privacy. QCon Software Development Conference Real-world technical talks. No product pitches. Practical ideas to inspire you and your team. QCon San Francisco - Oct 24-28, In-person. QCon San Francisco brings together the world's most innovative senior software engineers across multiple domains to share their real-world implementation of emerging trends and practices. Uncover emerging software trends and practices to solve your complex engineering challenges, without the product pitches.Save your spot now Home Create account Login QCon Conferences Events Write for InfoQ InfoQ Editors About InfoQ About C4Media Media Kit InfoQ Developer Marketing Blog Diversity Events * InfoQ Live JULY 19, 2022 * InfoQ Live AUGUST 23, 2022 * QCon San Francisco OCTOBER 24-28, 2022 * QCon Plus NOVEMBER 29 - DECEMBER 9, 2022 * QCon London MARCH 27-31, 2023 * QCon San Francisco OCTOBER 2-6, 2023 Follow us on Youtube212K Followers Linkedin18K Followers RSS19K Readers Twitter50k Followers Facebook20K Likes AlexaNew Stay in the know The InfoQ PodcastThe InfoQ Podcast Engineering Culture Podcast Engineering Culture Podcast The Software Architects' NewsletterThe Software Architects' Newsletter General Feedback feedback@infoq.com Advertising sales@infoq.com Editorial editors@infoq.com Marketing marketing@infoq.com InfoQ.com and all content copyright (c) 2006-2022 C4Media Inc. InfoQ.com hosted at Contegix, the best ISP we've ever worked with. Privacy Notice, Terms And Conditions, Cookie Policy BT *