Feedback-ID: i76984098:Fastmail
Message-ID: <29dc3d01-e89c-47b2-ae4c-1180f7edfd37@aklaver.com>
Date: Tue, 24 Dec 2024 08:49:07 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: repmgr(d) versions 5.5 vs 5.4 from apt.postgresql.org
To: Matthias Leisi <matthias@leisi.net>,
 pgsql-general <pgsql-general@postgresql.org>
References: <D79B1C7F-FAF3-4A89-95D7-F2C759777B2D@leisi.net>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <D79B1C7F-FAF3-4A89-95D7-F2C759777B2D@leisi.net>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/29dc3d01-e89c-47b2-ae4c-1180f7edfd37%40aklaver.com>
Precedence: bulk

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