by Jan Wieremjewicz | Sep 22, 2025 | Insight for DBAs, Percona Software, PostgreSQL, Security
This fall feels like a good moment to stop and look at what’s changed in PostgreSQL security over the last months and also what you can use right now to make your PostgreSQL deployments safer. PostgreSQL Transparent Data Encryption (TDE) from Percona For many...
by David Quilty | Sep 16, 2025 | Percona Software, PostgreSQL
If you’re running PostgreSQL in a regulated industry, you know the frustration: your compliance auditor demands data-at-rest encryption, but PostgreSQL doesn’t offer it natively. Your only options in the past? Pay premium prices for proprietary forks or...
by Pep Pla | Sep 8, 2025 | Insight for DBAs, MongoDB, MySQL, PostgreSQL, Security
Percona has a great set of tools known as the Percona Toolkit, one of which is pt-upgrade. The idea behind this tool is to replay a captured sequence of queries that were executed on a different database server. This is very useful to validate if a new version of the...
by Anil Joshi | Aug 20, 2025 | Insight for DBAs, PostgreSQL
In my previous blog post, Integrating Citus with Patroni: Sharding and High Availability Together, I explored how to integrate Citus with Patroni and demonstrated how basic table distribution works. In this follow-up post, I will discuss various other Citus...
by Michal Nosek | Aug 13, 2025 | PostgreSQL, Security, Webinars
I would like to thank everyone who attended my webinar, “No More Workarounds: Open Source PostgreSQL TDE Is Here,” on July 23, 2025. If you missed it, you can view the recording and slides. Here are the questions I had no time to answer during the live session. If you...
by Jan Wieremjewicz | Aug 5, 2025 | Insight for DBAs, PostgreSQL
PostgreSQL 18 is on the way, bringing a set of improvements that many organizations will find useful. It’s not a revolutionary release, but it does move things in a good direction, especially in performance, replication, and simplifying daily operations. For teams...
by Anil Joshi | Aug 4, 2025 | Insight for DBAs, Insight for Developers, PostgreSQL
Citus is a PostgreSQL extension developed with the intention of sharding and distributing the data across multiple machines. It offers features like distributed tables, reference tables, schema-based sharding and columnar storage. We have already covered the basics of...
by Shivam Dhapatkar | Aug 2, 2025 | Insight for DBAs, PostgreSQL
This post was originally written in 2023 and was updated in 2025. Encryption protects sensitive information by converting it into an unreadable format unless the correct passphrase or decryption key is supplied. In this post, we’ll look at how to encrypt the...
by Ibrar Ahmed | Aug 2, 2025 | Featured, Insight for DBAs, PostgreSQL, Security
This post was originally written in 2023 and was updated in 2025. Protecting sensitive information in PostgreSQL starts with strong authentication. It’s the process of verifying who’s trying to connect, whether through usernames and passwords, tokens, or one-time...
by Arunjith Aravindan | Jul 30, 2025 | Insight for DBAs, PostgreSQL
PostgreSQL streaming replication allows a standby server to continuously replicate data from a primary server. It operates by streaming Write-Ahead Log (WAL) segments from a primary server to one or more standby (replica) servers. The WAL segments contain a record of...
by Sergey Pronin | Jul 29, 2025 | Cloud, Percona Software, PostgreSQL
This post was originally published in 2023, and we’ve updated it in 2025 for clarity and relevance. Downtime is more than an inconvenience. For many organizations, even a short outage can mean lost revenue, broken customer trust, or compliance issues. PostgreSQL is a...
by Shivam Dhapatkar | Jul 28, 2025 | Insight for DBAs, PostgreSQL, Security
This post was originally published in 2023 and was updated in 2025. Security is always a moving target, and PostgreSQL 15 makes important changes that close off a long-standing risk: default privileges on the public schema. For years, any new user could create objects...
by Fernando Laudares Camargos | Jul 17, 2025 | Database Trends, Insight for DBAs, PostgreSQL
I admittedly have some work to do to catch up with the AI “trend”. It’s been around (as in, easily accessible) for a few years now, but I can probably still count on my fingers the number of times I’ve used a prompt to ask it anything. That is, discounting the mostly...
by Sergey Pronin | Jul 14, 2025 | Cloud, Insight for Developers, Percona Software, PostgreSQL
This blog was originally published in 2021 and updated in 2025. Running PostgreSQL in production means balancing high availability, disaster recovery, and scalability without adding unnecessary complexity. Kubernetes helps by providing a consistent way to orchestrate...
by Sergey Pronin | Jul 13, 2025 | Cloud, Percona Software, PostgreSQL
This post was originally published in 2022, and we’ve updated it in 2025 for clarity and relevance. PostgreSQL was initially released in 1996, when cloud-native was not even a term. According to DB engines, it is currently the fourth most popular relational open...
by Jorge Torralba | Jul 11, 2025 | Insight for DBAs, PostgreSQL
This post was originally published in 2022, and we’ve updated it in 2025 for clarity and relevance, reflecting current practices while honoring its original perspective. If you’re a DBA who’s comfortable with Oracle, MySQL, or SQL Server, stepping into PostgreSQL can...
by David Quilty | Jul 10, 2025 | Insight for DBAs, Insight for Developers, PostgreSQL
Do you find yourself struggling with geospatial data in your database? You know the feeling: you need quick answers about locations, distances, and relationships between points on a map, but your database just wasn’t built for these questions. The problem? While...
by Robert Bernier | Jul 8, 2025 | Insight for DBAs, Percona Software, PostgreSQL, Security
Welcome to the open source implementation of PostgreSQL Transparent Data Encryption! This question was posed on the PostgreSQL forum, and the good news is that it’s actually pretty easy to do! Q: Is it possible to automate the steps to enable pg_tde for all new...
by Agustín | Jul 5, 2025 | PostgreSQL, Security
This post was originally published in July 2022, and we’ve updated it in 2025 for clarity and relevance, reflecting current practices while honoring their original perspective. Protecting data in transit is just as important as protecting it at rest. If connections to...
by Pep Pla | Jul 3, 2025 | Insight for DBAs, MySQL, PostgreSQL
Welcome to this first installment of the blog series, which explores how PostgreSQL and MySQL deal with different aspects of relational databases. This post is about how to handle torn pages. As a long-time open source database administrator, I have always been...
