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@leisi.net
>
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
