News from EDB, including company and PostgreSQL announcements and events
Release Radar: EDB PG 15 Elevates Postgres as the Database Standard for EnterprisesBryan Turriff—12/8/2022
With EDB PG 15, EDB supports PostgreSQL 15.1 across a wide range of deployment options including on-premises, in the cloud, self-managed or fully managed with EDB BigAnimal. The release also adds PostgreSQL 15.1 support EDB Postgres for Kubernetes, which leverages CloudNativePG for speed, efficiency and protection for infrastructure modernization.
Psycopg2 to Psycopg3 migration in pgAdmin 4Khushboo Vashi—12/7/2022
Psycopg project released a major version, Psycopg3. pgAdmin 4 is immensely dependent on psycopg2 as it is being used as a database driver and the pgAdmin team decided to migrate to the new latest version and this blog is basically a migration guide for the python developers.
How to setup Two Factor Authentication in pgAdmin 4Akshay Joshi—12/7/2022
The purpose of this blog is to illustrate how to configure and setup Two Factor Authentication in pgAdmin 4.
Release Radar: Make Infrastructure Deployment Easier with EDB BigAnimal’s Terraform ProviderChristina Wong—12/6/2022
We’ve created a Terraform Provider for EDB BigAnimal with a few modules to start; we’ve also open-sourced the EDB BigAnimal Provider under the MPL 2.0 license so that you can contribute as desired.
Solving the Cloud Database Investment MysteryTom Rieger—12/6/2022
As you move your databases to the public cloud, it’s critical to understand how to balance performance expectations with costs so you can get the optimal return from your cloud database investment. The micro-billing of an environment makes the costing complex, with some sizing decisions bringing a large financial cost with no technical benefit. What are the things to consider and how can you compare different solutions on an equal footing?
Customer Spotlight Webinar Recap: Why Open Source and Postgres are at the Top of Telia’s IT AgendaEDB Team—12/5/2022
Being successful requires identifying and jumping on new business opportunities as they arise. As open source databases can provide a quick and efficient way to leverage new opportunities, many enterprises are adopting cloud and increasing their use of enterprise open source software for emerging technologies.
EDB Makes it Even Easier to Adopt Fully Managed Cloud Postgres as a ServiceChristina Wong—12/2/2022
Is getting top quality support your concern when using open source Postgres? Our new subscription plan combines open source Postgres backed by high quality technical support in a fully managed service so you can start reaping the benefits of Postgres right away.
EDB Partners with Cohesity to Expand Backup and Restore Capabilities for EDB Postgres Advanced ServerEDB Team—11/30/2022
The EDB GlobalConnect Technology Partner Program is pleased to announce that we have certified Cohesity DataProtect for PostgreSQL as a backup and restore solution to help customers protect the data in their EDB Postgres Advanced Server databases.
How to use an external database for pgAdmin user settingsAkshay Joshi—11/18/2022
The purpose of this blog is to illustrate how to save pgAdmin 4 configurations to an external database server. In addition, we covered examples that demonstrate how to use PostgreSQL server as an external database.
Listening to Postgres: How LISTEN and NOTIFY Syntax Promote High Availability at the Application LayerShaun Thomas —11/8/2022
Postgres provides several tools to simplify application development. Triggers, for example, allow one event to automatically invoke subsequent inserts, updates, or deletes to either reinforce business logic, or for auditing purposes. But are they valid for all such scenarios? Are there times when triggers would be detrimental to performance and scalability? What are our alternatives? Well, there’s only one way to find out!
Oracle Migration Webinar Recap Part 3: EDB Customer Success StoriesCecilia Aceti—11/7/2022
In the third and final part of this series (viewable on-demand), EDB’s Performance Engineering and Architecture Team VP, Vibhor Kumar and Solutions Architecture VP, Gianni Ciolli present real-life migration success stories, demonstrating how three different EDB customers successfully migrated from Oracle to Postgres.
Oracle Migration Webinar Recap Part 2: Tools and Resources to Ease Oracle to Postgres MigrationCecilia Aceti—10/28/2022
When we surveyed our customers in 2020 and asked them what they saw as obstacles when migrating from Oracle to Postgres, cost was their smallest concern, followed by migrating the database definitions, migrating the stored procedures and moving from proprietary drivers to Postgres open source drivers. Their largest concern? Migrating the data.
Harnessing Shared Buffers - Part 2Shaun Thomas —10/26/2022
In Part 1, we examined how Postgres behaves on older hardware with various allocations of Shared Buffers. This time we repeat those benchmarks on more contemporary hardware equipped with modern SSD storage. The difference this makes is dramatic and has far reaching implications. Join us as we discuss the continuing role of Shared Buffers in modern server deployments!
Release Radar: Apache Superset® is Now Available in BigAnimalNatalia Wojcik—10/26/2022
Starting today you can explore your data in BigAnimal using Apache Superset’s rich visualizations. Available upon request, Apache Superset® is an easy-to-use enterprise business intelligence tool that can process large amounts of data, turning them into charts and graphs.
How to Set Up Streaming Replication to Keep Your PostgreSQL Database Performant and Up-to-DateManish Yadav —10/12/2022
Streaming replication is a core utility of PostgreSQL introduced in version 9.0. Streaming replication allows a standby server to stay more up-to-date than is possible with file-based log shipping.
Release Radar: BigAnimal Now Supports Read-Only WorkloadsEDB Team—10/12/2022
With this week’s release, we’re supporting read-only workloads for high availability clusters. When you enable read-only workloads, you are given a connection string to your cluster’s standby replicas, allowing you to route read traffic to the standbys instead of the primary node.
Postgres vs. File Systems: A Performance ComparisonTomas Vondra—10/10/2022
One of the guiding Postgres design principles is heavy reliance on features provided by the environment (particularly operating system) and file systems are a prime example of this. Unlike other databases Postgres never supported raw devices that would require implementing a “custom” file system.
Harnessing Shared Buffers (and Reaping the Performance Benefits) - Part 1Shaun Thomas —10/7/2022
Postgres Shared Buffers remains one of the most difficult parameters to configure since its inception. Beyond an initial estimate, query patterns, relative storage performance, available resources, and realistic limits can all influence the final value entered here. Or is the picture far simpler than we thought? This is the first in a two-part series discussing the role of shared buffers in the past, and on more modern systems.
BigAnimal: Fully managed PostgreSQL in the cloud
BigAnimal features Oracle compatibility, built-in high availability, and 24/7 support from our team of PostgreSQL experts.Learn more
Demo of Oracle SQL compatibility in BigAnimal
BigAnimal lets you run Oracle SQL queries in the cloud via EDB Postgres Advanced Server. Watch the video, or load up psql and follow along.Learn more