PostgreSQL LDAP client authentication implementation Posted on March 20, 2024, updated on March 25, 2024 by Yannick JaquierTable of contents Preamble PostgreSQL LDAP client authentication implementation PostgreSQL LDAP client authentication testing References Continue reading
Citus as a distributed database plugin hands-on Posted on February 20, 2024, updated on February 21, 2024 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 Continue reading
How to online refresh BI tables with minimum impact to end users Posted on May 10, 2023, updated on May 10, 2023 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 Continue reading
Citus columnar storage hands-on Posted on March 28, 2023, updated on March 28, 2023 by Yannick JaquierTable of contents Preamble Citus installation Citus columnar storage testing preparation Citus columnar storage testing results References Continue reading
PostgreSQL logical replication hands-on Posted on September 1, 2022, updated on August 30, 2022 by Yannick JaquierTable of contents Preamble PostgreSQL configuration PostgreSQL logical replication configuration and testing PostgreSQL logical replication monitoring References Continue reading
PostgreSQL physical replication hands-on Posted on August 2, 2022, updated on August 2, 2022 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 Continue reading