by Ege Gunes | Feb 7, 2025 | Cloud, Percona Software, PostgreSQL
The upcoming Percona Operator for PostgreSQL v2.6.0 release introduces support for PostgreSQL 17, which opens exciting possibilities for data security. Since pg_tde comes pre-installed in Percona’s official PostgreSQL 17 images, this release presents an...
by David Quilty | Jan 22, 2025 | PostgreSQL, Security
Data security threats are becoming increasingly sophisticated, creating real challenges for organizations using PostgreSQL databases. While PostgreSQL is known for its reliability and feature-rich platform, a security breach can lead to serious consequences—damaged...
by Jobin Augustine | Jan 14, 2025 | Insight for DBAs, Insight for Developers, PostgreSQL
PostgreSQL is one of the most powerful database systems in the world. I have always been passionate about its great power, especially its modern SQL language features. However, that doesn’t mean everything is great. There are areas where it hurts. Novice users unaware...
by Valeria Bogatyreva | Jan 13, 2025 | Cloud, PostgreSQL
Originally published on The New Stack. Cloud-related regulatory, security and financial issues prompt many to weigh the benefits of building GenAI on on-premises and hybrid databases. Generative AI (GenAI) has already shown its potential to reshape industries,...
by David Quilty | Jan 11, 2025 | Insight for DBAs, Monitoring, PostgreSQL
Maybe queries that used to finish in milliseconds are now taking seconds. Perhaps your application is timing out during peak hours, or worse, users are complaining about slow page loads. By the time you notice something’s wrong, you’re already in crisis....
by Jan Wieremjewicz | Jan 9, 2025 | Open Source, PostgreSQL, Security
If you’re managing a PostgreSQL database and handling sensitive data or PII, the answer is simple: You need data-at-rest encryption. This isn’t just a “nice-to-have” feature—it’s often a legal or regulatory requirement. Compliance auditors, security...
by Anil Joshi | Jan 2, 2025 | Insight for DBAs, PostgreSQL
As we know, Patroni is a well-established standard for an HA framework for PostgreSQL clusters. From time to time, we need to perform maintenance tasks like upgrading the topology or making changes to the existing setup. Here, we will discuss mainly how we can replace...
by Robert Bernier | Dec 9, 2024 | Insight for DBAs, PostgreSQL
First things first, a couple of definitions to clear up: ETL: Extract, Transform, Load. Transforms data before loading it into the target system extract raw data from various sources use a secondary processing server to transform that data load that data into a target...
by Fernando Laudares Camargos | Nov 19, 2024 | Cloud, Monitoring, Percona Software, PostgreSQL
by Kai Wagner | Nov 18, 2024 | Open Source, Percona Software, PostgreSQL
PostgreSQL 12 reached its End of Life (EOL) on November 14, 2024. For more information, see the official PostgreSQL versioning policy page. This milestone marks the end of regular updates, bug fixes, and critical security patches for version 12. If you are still...
by Jan Wieremjewicz | Nov 6, 2024 | Cloud, Database Trends, Insight for DBAs, PostgreSQL
TL;DR Kubernetes was built for stateless apps, but as more stateful applications (like databases) run on it, operators include quite heavy implementations to Kubernetes workload management API (such as StatefulSets) deficits. While creating custom methods allows...
by Sergey Pronin | Nov 4, 2024 | Cloud, Percona Software, PostgreSQL
I wrote a blog post in the past about a generic approach on how to expose databases in Kubernetes with Ingress controllers. Today, we will dive deeper into PostgreSQL with ingress and also review two different ways that can be taken to expose the TCP service. The goal...
by Peter Zaitsev | Nov 1, 2024 | MySQL, Open Source, PostgreSQL
When I talk to old-timers in the MySQL community, I often hear this question: “How come MySQL is so awesome and still more popular than PostgreSQL (according to DB-Engines methodology at least), but it is losing ground while PostgreSQL’s growth in...
by Jan Wieremjewicz | Aug 15, 2024 | Open Source, Percona Software, PostgreSQL
When using a tool for a while, one often becomes patriotic towards it. With your investment, such as your work, you’re building up experience and starting to care more about the tool you use. How good it is, how it’s perceived by others. It’s an interesting process....
by Lalit Choudhary | Aug 13, 2024 | Insight for DBAs, PostgreSQL
Character collations determine the sort order and classification of characters. When creating a database with initdb, PostgreSQL normally sets the collation based on the operating system’s locale settings, but other special collations, such as “C,”...
by Alastair Turner | Aug 12, 2024 | Insight for DBAs, PostgreSQL
While the well-established ways of building PostgreSQL from source still work, there are many new options on Linux as well. Postgres has adopted Meson as a build system, and there are more—and more granular—git commands. There’s even a new way to describe the sources...
by Sergey Pronin | Aug 7, 2024 | Insight for DBAs, Percona Software, PostgreSQL
In the first part of this series, we built a basic AI-powered database agent. Now, it’s time to make a minimal viable product out of it. We’ll refine our scripts, add support for MySQL, incorporate OpenAI, and wrap everything in a user-friendly interface...
by Sagar Jadhav | Aug 6, 2024 | Insight for DBAs, PostgreSQL
The ALTER DEFAULT PRIVILEGES command allows us to set the privileges that will be applied to objects created in the future. It’s important to note that this does not affect privileges assigned to existing objects; default privileges can be set globally for...
by Sergey Pronin | Aug 5, 2024 | Open Source, Percona Software, PostgreSQL
Generative AI is top of mind for many engineers. The questions of how it can be applied to solve business problems and boost productivity are still up in the air. Recently I wrote a blog post about the impact of AI on platform engineers, where I talked about various...
by Shivam Dhapatkar | Jul 10, 2024 | Insight for DBAs, PostgreSQL
The PostgreSQL Global Development team released the second beta version of PostgreSQL 17 on June 27th, 2024, and it is now available for testing. In this beta version, we can explore the new features that will be released in the official final release of PostgreSQL...
