In the previous blog, we explored the importance of securing data at rest, focusing on encryption methods and best practices to protect sensitive information stored within PostgreSQL databases. As we…
Recently, I gave a presentation on database security, focusing on essential aspects such as users, roles, permissions, Row-Level Security (RLS), and Column-Level Security (CLS). Inspired by that experience, I thought…
How to do PITR with pgBackRest and Patroni Preparation: Backups: Ensure you have a recent pgBackRest backup available for the desired PITR time. This could be a full backup or an…
Unveiling the Magic: Patroni's High Availability Workings for PostgreSQL Demystify Patroni, the high availability solution for PostgreSQL. This guide dives deep into its internal mechanisms, exploring leader election, health monitoring,…
Understand your learnings with FAQs and MCQs This guide explores how Frequently Asked Questions (FAQs) and Multiple Choice Questions (MCQs) can be powerful tools to solidify your understanding of any…
Major Upgrade of PostgreSQL Version Ready to leverage the latest features and performance enhancements of a newer PostgreSQL version? This guide empowers you to perform a major version upgrade on…
Safeguarding Your Patroni PostgreSQL Cluster with pgBackRest on CentOS Running a PostgreSQL cluster with Patroni offers high availability, but ensuring data protection requires robust backups. This guide introduces you to…
Integrating Patroni setup with pgBouncer Patroni and pgBouncer are powerful tools for building highly available (HA) PostgreSQL clusters. While Patroni manages leader election and failover for your PostgreSQL instances, pgBouncer…
PostgreSQL is available on RHEL/Cent OS by default as AppStream. As per RHEL documentation, RHEL/CentOS comes with a new feature called Application Streams (AppStreams), in which multiple versions of packages…
How to Set Up a Highly Available PostgreSQL 16 Cluster on Cent OS 9 using repmgr IP Address Host Role 192.168.110.222 pghelp01 primary 192.168.110.223 pghelp02 standby 192.168.110.224 pghelp03 witness Set…