News, articles, customer success stories, and tutorials on PostgreSQL, open source, EDB, and more
Wharton Research Data Services Leverages Postgres and EDB ExpertiseEDB Team—5/18/2022
Key WRDS Benefits Democratizes data access so that all disciplines can easily search for concepts across the data repository. Expands on and improves capabilities with the help of core Postgres team members working at EDB, leverag ...
Least Privileged User Vulnerability Identified in Postgres with CVE-2022-1552Dan Garcia—5/18/2022
Included in the latest update release from the PostgreSQL Global Development group is a critical fix for a newly disclosed security vulnerability CVE-2022-1552.
Report: Government Agencies are Future-Proofing Their Data Initiatives with PostgresEDB Team—5/16/2022
In order to better understand how government organizations are currently using Postgres, EDB collaborated with GovLoop on their recent report “How to Future-Proof Your Data Initiatives.”
What Is Database-as-a-Service (DBaaS)? Tutorial on How to Use Managed Database Service for PostgreSQLMarc Linster—5/16/2022
Learn what database-as-a-service (DBaaS) is, and how you can save money by using it. Find out more about the pros and cons of DBaaS to find the right solution for your organization.
PG Phriday: What You Should Know About Basic Postgres AuthenticationShaun Thomas —5/11/2022
Frequent participants in the Postgres Discord and Slack servers, mailing lists, IRC chat, and other Postgres hangouts often hear a common refrain: I’ve installed Postgres, so now what? We may be tempted to say “Go forth young one, and explore!” Yet there’s a more fundamental question left unanswered: how do you even connect to explore in any capacity? What does that entail? Let’s explore how to connect to a fresh Postgres installation, and see what a new user really needs to know in order to experiment with Postgres.
Query Tool vs View/Edit DataNikhil Mohite —5/10/2022
pgAdmin 4 provides 2 different ways to execute queries on the database: * Query tool: You can write and execute custom queries on any table in the connected database. * View/Edit data: View/Edit data can be used to view or modify a particular table's data.
Introducing CloudNativePG: A New Open Source Kubernetes Operator for PostgresGabriele Bartolini—5/10/2022
If your organization requires professional assistance on Postgres in Kubernetes with CloudNativePG, you can take advantage of EDB’s leading expertise. Gabriele will be speaking about Kubernetes in Postgres at the Data on Kubernetes Day before KubeCon Europe 2022.
Release Radar: BigAnimal Generally Available on AWSEDB Team—5/5/2022
BigAnimal is EDB’s fully managed Postgres database in the cloud and includes built-in Oracle compatibility and EDB’s Postgres expertise. BigAnimal on AWS comes with all of the key capabilities you need for your enterprise applications.
Use of the Master Password in pgAdmin 4Akshay Joshi—4/22/2022
pgAdmin 4 introduced the Master Password in order to secure and later unlock saved server passwords. Any password that is saved in the SQLite DB file - used for storing user preferences and other data - through the save password or save SSH tunnel password option will be encrypted and decrypted using the master password.
Webinar Recap: Fuel the DevOps Movement and Innovate Faster with Cloud Native PostgresEDB Team—4/21/2022
Recently, EDB hosted a webinar entitled Fuel the DevOps Movement and Innovate Faster with Cloud Native Postgres, featuring Gabriele Bartolini, EDB’s Vice President of Cloud Native, and Jan Karremans, EDB’s Global Director of Product Marketing.
Steady Storage StampedeShaun Thomas —4/21/2022
High Availability is more than just choosing the right architecture, replication tools, and failover systems. Storage can play a surprisingly important role in server responsiveness, as can somewhat obscure operating system tuning parameters. This week in PG Phriday, we’re going to examine just how important storage behavior can be to Postgres High Availability.
Why Mastercard's Secret to Zero Downtime is PostgresEDB Team—4/21/2022
Mastercard has used an array of database technologies, including Oracle, MySQL, Microsoft SQL Server, Cassandra, Hadoop, DB2 and PostgreSQL, for years. In my role as Lead BizOps Engineer, I support the payment gateway, which Mastercard acquired in 20 ...
Choose Your Own Adventure: Test Drive BigAnimal in AWSChristina Wong—4/6/2022
Now, with this latest release, you can choose your own adventure, and test drive BigAnimal on AWS or Azure. With a single user interface, you can connect your Azure applications to BigAnimal one day, and your AWS application the next.
Release Radar: Leverage Azure Monitor Workbooks for Your BigAnimal ClustersEDB Team—4/6/2022
We’ve built Workbooks for your BigAnimal clusters that are accessible directly from the Azure Portal with no need for you to take any extra steps. Let’s get into how to find and interpret the Workbook for your cluster.
This Year’s Grammys Demonstrate Technology Innovation Driving Engagement Across the Music IndustryEDB Team—4/4/2022
The 64th Annual Grammy awards were a showcase for disruption. As an industry that once viewed technologies such as digitization and streaming as threats to creativity and profitability, the Awards demonstrated quite the opposite across the music industry.
PG Phriday: Tidying Up With VACUUMShaun Thomas —4/1/2022
Hot on the heels of our discussion on preventing Postgres XID wraparound using basic monitoring, let’s talk about arresting the risk almost entirely through Autovacuum. With a few relatively minor tweaks to our configuration and focusing on the occasional problematic table, we can both increase maintenance throughput, and also reduce impact on client queries. Let’s demystify the art of VACUUM and keep our cluster self-maintaining in the bargain.
PostgresBuild 2021 Session Highlights: Dr. Michael Stonebraker on Acceleration and the Future of CloudJan Karremans—3/31/2022
The founder of what we, today, know as Postgres offers guidelines for the future of the cloud. Not only from a historical perspective, but very much forward-looking.
Release Radar: BigAnimal Expands Support for Compute ChoicesEDB Team—3/30/2022
BigAnimal, EDB’s fully managed cloud Postgres database, runs in your Azure account on Azure instances. The EDB team is happy to announce that BigAnimal now supports new compute choices, for a total of 5 supported Azure instance series.
EDB and Veritas Partner to Secure EDB Products with Veritas’ Updated NetBackup SolutionEDB Team—3/25/2022
In 2019, EDB collaborated with Veritas to help businesses secure their data and protect EDB Postgres Advanced Server via Veritas’ NetBackup™. Now, we’re pleased to announce Veritas as the latest member of EDB’s growing partner program.
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