News, articles, customer success stories, and tutorials on PostgreSQL, open source, EDB, and more
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.
Don't Be the Next PII Horror Story: Postgres Best Practices for Securing Sensitive DataVibhor Kumar—12/7/2022
In recent years, it seems like not a month goes by without the story of a high-profile data leak, forcing companies to reassess how they’re handling their own PII to prevent their name from appearing in the next headline. After all, these incidents have major consequences—damaging revenue, reputations and potentially opening businesses up to legal repercussions
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.
[Infographic] Shaping the Future of Postgres: A Look at EDB's Major Contributions Over the YearsAdam Wright—12/1/2022
Because a picture tells a thousand words, we compiled an infographic detailing how EDB has improved Postgres over the years. One of our most exciting developments was introducing the MERGE command this year, which makes it easier for enterprises to migrate from expensive, legacy databases to open source (version 15 of Postgres).
You Need to Check Your PostgreSQL Version. Here’s How and WhyDoug Ortiz—12/1/2022
We strive to help enterprises dedicated to innovation take full advantage of what their PostgreSQL and open source strategy can be, with every subsequent version. Whether it’s advising on new features, providing enterprise-grade support or shepherding businesses through major infrastructural projects, EDB has distinguished itself as the PostgreSQL leader.
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.
SAS Deploys and Operationalizes an Enterprise Postgres Database With Help From EDBEDB Team—11/30/2022
SAS is the leader in analytics and the largest independent vendor in the business intelligence market. Through innovative analytics and artificial intelligence, SAS empowers and inspires customers around the world to transform data into intelligence. SAS serves customers in 150 countries, with its software installed at more than 80,000 business, government, and university sites.
Timing is Everything for Trading Applications: Don’t Lose with Database Extreme High AvailabilityCelest Turner Hall—11/21/2022
The world of online trading platforms is allowing more people to take control of their financial futures and creating new opportunities for innovation among application and platform providers. In order to compete, however, these providers need to have a database that can keep pace with the demands of the industry and expectations of their users.
Modern Database Strategies Survey: Why Executives Have Everything to Gain by Moving to PostgresEDB Team—11/18/2022
If, like these executives in the survey, you want to eliminate vendor lock-in and increase scalability by moving to open source, don’t let a perceived lack of Postgres knowledge hold you back! Our fully managed Postgres in the cloud service handles database maintenance for you, so you can focus on business innovation.
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.
Critical Capabilities for Cloud Database Management Systems for Analytical Use Cases – Gartner® ReportCecilia Aceti—11/15/2022
Gartner's extensive “2021 Critical Capabilities for Cloud Database Management Systems for Analytical Use Cases” report is designed to help organizations evaluate the strengths and weaknesses of both native services offered by CSPs and fully cloud-based systems.
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.
Cloud Usage Survey: The Results Are In From Microsoft IgniteChristina Wong—11/1/2022
Microsoft recently held their annual Ignite Conference as a primarily online event, with an in-person presence in select cities around the world. We asked Microsoft Ignite attendees about their cloud usage and the benefits they expect from fully managed databases. Read on to see the results.
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