PostgreSQL PAM Authentication
Guide for configuring PAM (Pluggable Authentication Modules) authentication in PostgreSQL, including integration with LDAP for centralized user management.
PostgreSQL LDAP User Sync
Automatically synchronize users and groups from LDAP/Active Directory to PostgreSQL using pg-ldap-sync. This eliminates manual user management and keeps database access aligned with your directory service.
Upgrading PostgreSQL on AlmaLinux
Complete guide for upgrading PostgreSQL from one major version to another (e.g., 17 to 18) on AlmaLinux/RHEL-based systems using pg_upgrade.
PostgreSQL Streaming Replication
Guide for setting up PostgreSQL streaming replication with a primary-standby configuration, including optional Pgpool-II for connection pooling and automatic failover.
High Availability with Patroni & etcd
Complete guide for setting up a PostgreSQL high-availability cluster using Patroni for automatic failover and etcd for distributed configuration storage.
PostgreSQL Foreign Data Wrapper (FDW)
Guide for setting up and using PostgreSQL Foreign Data Wrappers to access data from remote databases as if they were local tables.