On 12/24/24 01:28, Matthias Leisi wrote:
I installed Postgres 16/17 from apt.postgresql.org
<http://apt.postgresql.org> (with the intent of using version 17) on
Debian 12/Bookworm. Both have the same version of repmgr:
postgres@dev-pgcl01:~$ /usr/lib/postgresql/17/bin/repmgr --version
repmgr 5.5.0
postgres@dev-pgcl01:~$ /usr/lib/postgresql/16/bin/repmgr --version
repmgr 5.5.0
root@dev-pgcl01:~# apt-cache show postgresql-17-repmgr | grep "Filename"
Filename:
pool/main/r/repmgr/postgresql-17-repmgr_5.5.0-2.pgdg120+1_arm64.deb
In postgresql.conf, I explicitly load the version 17 .so (just to be
sure it’s not loading something potentially different):
shared_preload_libraries = '/usr/lib/postgresql/17/lib/repmgr.so'
repmgr.conf is minimalistic:
node_id=1
node_name=node1
conninfo='host=10.20.70.26 user=repmgr dbname=repmgr connect_timeout=2'
data_directory='/var/lib/postgresql/17/'
failover=automatic
use_replication_slots=true
promote_command='/usr/bin/repmgr standby promote -f
/etc/postgresql/17/main/repmgr.conf --log-to-file'
follow_command='/usr/bin/repmgr standby follow -f
/etc/postgresql/17/main/repmgr.conf --log-to-file --upstream-node-id=%n‘
(plus a few configs about the logs)
The suggested ALTER EXTENSION from the log hint does not do anything I
could see.
The same effect if I try the same using version 16.
How to continue from here? What am I missing?
Maybe as shown here:
https://www.repmgr.org/docs/current/configuration-file-optional-settings.html
"
pg_bindir (string)
Path to the PostgreSQL binary directory (location of pg_ctl,
pg_basebackup etc.). Only required if these are not in the system PATH.
[...]
Debian/Ubuntu users: you will probably need to set this to the
directory where pg_ctl is located, e.g. /usr/lib/postgresql/9.6/bin/.
"
Also looks to me like there is version 5.4 installed somewhere else that
is being picked up. I would do a find to locate out all the repmgr
instances installed.
Thanks for your help,
— Matthias
--
Matthias Leisi
Katzenrütistrasse 68, 8153 Rümlang
Mobile +41 79 377 04 43
matthias@xxxxxxxxx
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx