2ndQuadrant released on 22nd of October 2020 repmgr 5.2.0. Repmgr is an open-source tool suite for managing replication
and failover in a cluster of PostgreSQL servers. A tool, which I personaly like a lot.
On of the main big features is of course the support for PostgreSQL 13.
However, the one I was interested in, is the repmgr cluster crosscheck command. The crosscheck command simply cross checks
the connections between each combination of nodes.
This command worked beforehand (version 5.1.0) very well, however, the output was kind of mal formatted, if the id’s are longer, like in the following output.
$ repmgr -f ${PGNAME}/etc/repmgr.conf cluster crosscheck
INFO: connecting to database
Name | Id | 550001 | 550002
--------+----+----+----
host001 | 550001 | * | *
host002 | 550002 | * | *
So I opened an request in the repmgr forum (https://groups.google.com/g/repmgr) and asked if they could please fix that issue, because I’m using long id numbers
a lot.
And here we go. They did it. Take a look at the repmgr 5.2.0 release notes.
https://repmgr.org/docs/current/release-5.2.0.html
- repmgr cluster crosscheck / repmgr cluster matrix: improve text mode output format, in particular so that node identifiers of arbitrary length are displayed correctly.
And now the output looks very good. You will notice the difference immediately.
$ repmgr -f ${PGNAME}/etc/repmgr.conf cluster crosscheck
INFO: connecting to database
Name | Id | 550001 | 550002
--------+--------+--------+-------
host001 | 550001 | * | *
host002 | 550002 | * | *
This is a small example how good the PostgreSQL community works. Thanks a lot to the 2ndQuadrant developers who took care of my issue.
Cheers
William