Blog

:PostgreSQL Experts

EDB recently hosted a webinar entitled “Why Postgres is Becoming the Standard in Financial Services.” We wanted to explore the reasons for this trend, why they matter to you and what you can do to take advantage of this sea change.

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.

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.”

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.

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.

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.

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.

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.

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.

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.

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 ...

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.

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.

pgAdmin 4 can be installed in Desktop mode for individual users or in Server mode to support multiple remote users.

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.

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.

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.

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.

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.

In pursuit of modernizing, many businesses have begun incorporating Postgres into their database infrastructures. As an open source relational database management system (RDBMS), Postgres has become synonymous with innovation since its inception in 1996.