PostgreSQL 12 High Availability Cookbook - Third Edition

There's more...

What about upgrading repmgr itself? It's important to understand that repmgr operates both as a PostgreSQL extension and as a piece of software that includes a management daemon. The procedure outlined here also applies to upgrading repmgr itself, but there's an important caveat.

Between major versions, from 4.4 to 5.0 for example, it's possible that incompatibilities may have been introduced that affect the PostgreSQL extension. When this happens, it becomes necessary to manually upgrade the extension within the repmgr metadata database. It can also only be done on the primary node since we must write to that database.

We can use the following steps to accomplish this goal:

1. Stop repmgrd on all nodes using systemctl.
2. Explicitly ...