PostgreSQL logical replication hands-on Posted on September 1, 2022, updated on August 30, 2022 by Yannick Jaquier Table 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 Jaquier Table 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
PostgreSQL graphical monitoring tools comparison Posted on August 28, 2021, updated on September 20, 2021 by Yannick Jaquier Table of contents Preamble pgAdmin Postgres Enterprise Manager Postgres Enterprise Manager Server Postgres Enterprise Manager Agent OmniDB Percona Monitoring and Management Server Client PGWatch To be continued... References Continue reading
PostgreSQL backup and restore tools comparison for PITR recovery Posted on July 28, 2021, updated on August 2, 2021 by Yannick Jaquier Table of contents PostgreSQL backup and restore Pg_basebackup PgBackRest EDB Backup and Recovery Tool Barman To be continued... References Continue reading