PostgreSQL LDAP client authentication implementation Posted on March 20, 2024 , Modified on October 12, 2026 , by Yannick JaquierTable of contents Preamble PostgreSQL LDAP client authentication implementation PostgreSQL LDAP client authentication testing References Read more PostgreSQL Security Leave a comment
Citus as a distributed database plugin hands-on Posted on February 20, 2024 , Modified on September 22, 2026 , by Yannick JaquierTable of contents Preamble Citus distributed database installation Citus distributed database configuration Citus distributed database testing Citus distributed database cluster management Handle node failure Removing nodes Adding nodes References Read more PostgreSQL High Availability Leave a comment
How to online refresh BI tables with minimum impact to end users Posted on May 10, 2023 , Modified on October 13, 2026 , by Yannick JaquierTable of contents Preamble Preparation of the test environment The old legacy technique The alter table switch technique The view technique The synonym technique The schema transfer technique Conclusion References Read more MariaDB, MySQL, Oracle, PostgreSQL, SQL Server Development, SQL Leave a comment
Citus columnar storage hands-on Posted on March 28, 2023 , Modified on March 10, 2026 , by Yannick JaquierTable of contents Preamble Citus installation Citus columnar storage testing preparation Citus columnar storage testing results References Read more PostgreSQL Development, Tuning 1 comment
PostgreSQL logical replication hands-on Posted on September 1, 2022 , Modified on August 30, 2022 , by Yannick JaquierTable of contents Preamble PostgreSQL configuration PostgreSQL logical replication configuration and testing PostgreSQL logical replication monitoring References Read more PostgreSQL High Availability Leave a comment
PostgreSQL physical replication hands-on Posted on August 2, 2022 , Modified on July 10, 2026 , by Yannick JaquierTable of contents Preamble Primary server setup Standby server setup for physical replication Without streaming replication With streaming replication Replication slots for physical replication Promoting a standby node Physical replication monitoring All in one pg_basebackup remote command References Read more PostgreSQL High Availability 3 comments