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…
https://www.youtube.com/watch?v=JDeD2chhIW0&t=917sPostgreSQL is a popular open-source relational database management system (RDBMS) used by many organizations to store and manage their data. To ensure high availability and prevent downtime, it's essential to…
How to add a postgres user at operating system level [crayon-678a331554339337912062/] How to install PostgreSQL pre-requisites in Centos 9 [crayon-678a331554349505514792/] How to install and Configure PostgreSQL v16 in Cento os…
Context - 1Whether you're a novice embarking on a career as a database administrator or an experienced professional from another RDBMS technology, People often ask me about how to kickstart…
PostgreSQL is a popular open-source relational database management system (RDBMS) used by many organizations to store and manage their data. To ensure high availability and prevent downtime, it's essential to…
Per PostgreSQL 14 release notes "When using logical replication, PostgreSQL can now stream in-progress transactions to subscribers, with significant performance benefits for applying large transactions on subscribers. PostgreSQL 14 also…
As per the "State of PostgreSQL 2021" survey by timescale for the best visualization tool, Grafana stood first with 38.7% responders. In this post, we are going to configure Grafana…
In this tutorial we will understand how to setup a Pivotal Greenplum 6 database cluster with following set up on Linux 6. How to Install, Create and Configure Greenplum database…