by Nam Dinh Phuong | Dec 17, 2025 | Insight for DBAs, PostgreSQL
Database interoperability is a common requirement in enterprise environments. For users seeking to access Oracle data from a PostgreSQL instance, the native PostgreSQL extension oracle_fdw (Foreign Data Wrapper) is an excellent and efficient solution. However, the...
by David Quilty | Dec 12, 2025 | Percona Software, PostgreSQL
Support shifts for hardened builds draw quick attention in regulated sectors, so when discussions surface about the future of a distribution, teams responsible for compliance and continuity take notice. Recent community discussions and rumors suggest that Crunchy...
by Pep Pla | Dec 11, 2025 | Insight for DBAs, MySQL, PostgreSQL
Being a Tale of Databases, Binary Logs, WAL Files, and the Redemption of Ebenezer Scrooge, DBA Part the First — In Which We Meet Ebenezer Scrooge, Database Administrator Extraordinary It was a cold, dark, and CPU-bound night. The wind blew fierce across the datacenter...
by Ashish Joshi | Dec 1, 2025 | Insight for DBAs, PostgreSQL
A Nightmare no DBA wants One day, I had a nightmare, the kind every DBA fears. My manager called me and said, “Hey… Mr. Clever. We don’t need you on the team anymore.” I panicked. “What did I do wrong?!” He replied, “You tell me. Think about your ‘great’ work...
by Anil Joshi | Nov 21, 2025 | Cloud, Hardware and Storage, Insight for DBAs, PostgreSQL
Having a stand-by cluster ensures maximum data availability and a disaster recovery solution. In this blog post, we will cover how to set up a standby cluster using streaming replication and how to create an ad-hoc/standby cluster that uses a remote pgBackRest...
by Robert Bernier | Nov 20, 2025 | Insight for DBAs, Insight for Developers, PostgreSQL
Unlike the standard multi-node Postgres replication cluster, when managed by Patroni, all failovers are automatically executed. However, this is not the case when dealing with inter-datacentre failovers when for instance a standby datacentre must take over from a...
by Jobin Augustine | Nov 19, 2025 | Insight for DBAs, PostgreSQL
Is your PostgreSQL database Feeling Sluggish? Are SQL statements taking more time than in earlier days? Are you experiencing performance cliffs (Unexpected, sudden drops in performance)? Are backups taking a long time to complete? Are you getting a bigger bill for...
by Pep Pla | Nov 14, 2025 | Insight for DBAs, MySQL, PostgreSQL
I’m lazy when I’m speakin’ I’m lazy when I walk I’m lazy when I’m dancin’ I’m lazy when I talk X-Press 2 Feat. David Byrne – Lazy While preparing a blog post to compare how PostgreSQL and MySQL handle locks,...
by Fernando Laudares Camargos | Nov 12, 2025 | Open Source, Percona Software, PostgreSQL
Among the new fetures introduced in PostgreSQL 18 is support for OAuth-based authentication. This opened the door for the community to create extensions that integrate systems providing Single Sign-On (SSO) through OAuth 2.0 authentication with PostgreSQL. The reason...
by Jobin Augustine | Nov 6, 2025 | Insight for DBAs, PostgreSQL
PostgreSQL 13 will officially reach End-of-Life (EOL) on November 13, 2025. After this date, the PostgreSQL Global Development Group will stop releasing security patches and bug fixes for this version. That means if you’re still running PostgreSQL 13, you’ll soon be...
by Anil Joshi | Oct 31, 2025 | Cloud, Hardware and Storage, Insight for DBAs, PostgreSQL
Having a centralized repository (such as Cloud/S3) is crucial for data backup and recovery purposes. It also provides ease when needed to restore the data over different machines/instances. MinIO is one such S3-compatible storage solution that can be deployed anywhere...
by Robert Bernier | Oct 27, 2025 | Cloud, Insight for DBAs, Insight for Developers, PostgreSQL
PostgreSQL logical replication adoption is becoming more popular as significant advances continue to expand its range of capabilities. While quite a few blogs have described features, there seems to be a lack of simple and straightforward advice on restoring stalled...
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...
