This content is password protected. To view it please enter your password below: Password ..read more

This content is password protected. To view it please enter your password below: Password ..read more

This content is password protected. To view it please enter your password below: Password ..read more

This content is password protected. To view it please enter your password below: Password ..read more

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 are provided, with a known period of support. These modules can be thought of as package groups that represent an application, a set of tools, or runtime languages. We can see the list of modules available modules to us after a fresh installation of RHEL 9 using the below command yum module list How to install default version of PostgreSQL using AppStream? RHEL/Cent OS 9 provides Postg ..read more

This content is password protected. To view it please enter your password below: Password ..read more

This content is password protected. To view it please enter your password below: Password ..read more

Context – 1 Whether 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 the PostgreSQL administration journey or take it to the next level Context – 2 Typical use cases that we hear from the PostgreSQL community or the requirement from your manager I want to set up PostgreSQL on my on-premise. Can you help me with PostgreSQL configuration best practices?. Can you help me migrate my Oracle/SQL Server database to PostgreSQL? I am pushing my data f ..read more

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 have a robust HA setup for PostgreSQL. Patroni, HAProxy, Keepalived, etcd, and watchdog can be used together to achieve this goal. Patroni: Patroni is an open-source tool used to manage PostgreSQL HA clusters. It’s a lightweight solution that uses the PostgreSQL replication mechanism to ensure that all nodes in the cluster have an up-to-date copy of the database. Patroni provides automat ..read more

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 have a robust HA setup for PostgreSQL. Patroni, HAProxy, Keepalived, etcd, and watchdog can be used together to achieve this goal. Patroni: Patroni is an open-source tool used to manage PostgreSQL HA clusters. It’s a lightweight solution that uses the PostgreSQL replication mechanism to ensure that all nodes in the cluster have an up-to-date copy of the database. Patroni provides automat ..read more