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...
by Sergey Pronin | Jul 8, 2024 | Cloud, Percona Software, PostgreSQL
PostgreSQL major versions are released every year, with each release delivering better performance and new features. With such rapid innovation, it is inevitable that there will be a need to upgrade from one version to another. Upgrade procedures are usually very...
by Bhargav Kamineni | Jul 3, 2024 | Insight for DBAs, PostgreSQL
In one of our previous blogs, a custom method for switching from PostgreSQL physical replication to logical replication was discussed, using pg_create_logical_replication_slot and pg_replication_slot_advance. PostgreSQL 17, set to be released this year, introduces the...
by Neha Korukula | Jul 2, 2024 | Insight for DBAs, PostgreSQL
In this blog, we will see the concepts for analyzing WAL files, such as pg_waldump (supported versions 12 and above) and pg_walinspect (supported versions 15 and above). Write-Ahead Logging (WAL) is a standard approach to transaction logging and one of the...
by Abhishek Deb | Jul 1, 2024 | Insight for DBAs, PostgreSQL
In PostgreSQL, an “orphan large object” refers to a large object (LOB) that exists in the pg_largeobject system table but is not associated with any specific row in a user-defined table. This situation can occur due to various reasons, such as when the...
by Sonia Valeja | Jun 25, 2024 | Insight for DBAs, PostgreSQL
PostgreSQL is a powerful and versatile relational database management system that provides many features for managing and manipulating databases. One such feature is the is_template flag, which can be used to create and manage template databases. In this blog post, we...
by Jobin Augustine | Jun 24, 2024 | Insight for DBAs, PostgreSQL
We have been promoting and using Patroni as the best high availability framework for PostgreSQL, and Etcd was the preferred/recommended DCS for the Patroni cluster. Both Patroni and Etcd have been part of PostgreSQL distribution from Percona for years now. But one...
by Sveta Smirnova | Jun 12, 2024 | MongoDB, MySQL, Percona Software, PostgreSQL
Percona Toolkit 3.6.0 has been released on June 12, 2024. The most important updates in this version are: The possibility to resume pt-online-schema-change if it is interrupted. eu-stack support in pt-pmp that significantly improves this tool’s performance and...
by Robert Bernier | Jun 5, 2024 | Insight for DBAs, Insight for Developers, PostgreSQL
There are quite a number of methods these days for installing Patroni. I want to discuss the next step, which is how to start tuning a running system. The manner of updating a running Postgres server typically involves editing the standard Postgres files:...
