Postgres 14 released!
A variety of new features that help developers and administrators deploy their data-backed applications.
Overview
EDB Postgres offers an integrated, open-source-based SQL relational database solution built for your enterprise-scale data needs. A rich set of extended capabilities support cost-effective, resilient production and non-production environments. Organizations can come to IBM to license, implement and get support for EDB Postgres and enjoy the tested and certified PostgreSQL for high availability, disaster recovery, and monitoring.
Benefits
Flexible deployment
Deploy and integrate across any environment needed by your business: cloud — public, private and hybrid; virtualized, containers and bare metal.
Improved productivity
Get developer-friendly support for the latest programming languages and IDEs, such as JavaScript, JSON, Python, XML, and more.
Multiple data types
Use your data type of choice. EDB Postgres handles most structured, semi-structured or unstructured data natively.
Modernize your data architecture
Support advanced analytics and AI models by running MongoDB Enterprise Advanced on IBM Cloud Pak for Data.
Feature spotlight
Enterprise security
Enterprise security
EDB delivers security through ANSI SQL GRANT and REVOKE. It offers external authentication support for LDAP, PAM and Kerberos. It also offers granular object permissions, operational auditing, a virtual private database, and protection against SQL injection attacks.
Advanced performance
Advanced performance for critical workloads
Advanced partitioning enable smarter, faster partition pruning. Ensure critical transactions have resource priority over other workloads. Dynamic Runtime Instrumentation Tools Architecture (DRITA) analyzes system and session wait events to identify bottlenecks.
Database compatibility
Database compatibility to minimize migration efforts
EDB natively processes existing PL/SQL programs and data without translation layers and without costly consulting engagements. EDB compatibility means your performance expectations are preserved, intellectual capital is protected and staff can focus on important tasks.
DBA and developer features
DBA and developer features
EDB provides tools and functionality such as EDB*Loader and extended catalog views. Twenty-one packages with more than 250 functions, bulk collect and bind, user-defined object types, and more reduce programming effort and provide faster processing.
Featured product
IBM Cloud Pak for Data
The next generation of IBM Cloud Pak for Data provides a data fabric for faster, trusted AI outcomes. Connect the right data, at the right time, to the right people, from anywhere it’s needed. Use one fully managed experience across hybrid cloud to ingest, explore, prepare, manage, govern and serve petabyte-scale data for business-ready AI.
What’s new in Postgres 14
Enhanced security
Enhanced security
The default authentication for PostgreSQL going forward has now changed to SCRAM-SHA-256 to ensure that new users take full advantage of this important security feature, deprecating MD5 for new users.
Standardization
Standardization
Server-side functions and procedures that use LANGUAGE SQL can now use SQL-standard compliant function bodies. Graph-query support is enhanced by SEARCH and CYCLE clauses, which improve the ease of writing complex graph queries in PostgreSQL.
Developer friendly
Developer friendly
Stored procedures give transactional control within the code base. PostgreSQL 14 implements the OUT parameter, allowing developers to return data using multiple parameters in their stored procedures. A common feature within Oracle, this functionality is a welcome addition for developers trying to migrate from Oracle to PostgreSQL.
Explore IBM data ecosystems
SingleStore DB with IBM
SingleStore DB is a modern SQL database for data-intensive workloads. With near ubiquitous connectivity driving high-velocity, high-volume data workloads.
MongoDB Enterprise Advanced with IBM
A robust, scalable, highly available document database solution that enables developers to build apps faster and better distribute data.
Open source databases
IBM open source database solutions help implement a hybrid data environment that includes both relational and non-relational components.
Use cases
Migrate more apps from Oracle
Migrate more apps from Oracle
Advanced queuing supports a range of application migrations from Oracle to EDB, including applications used for financial transactions, user profile data and system of record information.
Manage larger data sets
Manage larger data sets
Robust partitioning capabilities — including fast pruning for more data types and prepared statements — better enable EDB Postgres Advanced Server 9.6 to support clients with larger data sets.
Build better configurations
Build better configurations
Build more robust and flexible configurations using clustering, scale out and integration features. Use synchronous apply confirmation to build truly read scalable clusters.
Resources
IBM® Data Management for EDB Postgres Enterprise
Learn how to integrate open source databases into your existing data management solution.
Deploying Postgres databases in containers
Read up on the advantages of containerized databases and how EDB accelerates that process.
EDB and IBM announce multiyear partnership
Learn about how IBM clients can take advantage of EDB Postgres.
IBM and EDB enhance Postgres solution
Learn about using open source databases and the benefits of the Enterprise and Standard editions.
Code pattern for helpdesk service ticket app
Create a web application that tracks support tickets using EDB and Vue.js.
Talk to an IBM expert to help you build a modernized, enterprise-ready data architecture with PostgreSQL.