public inbox for [email protected]
help / color / mirror / Atom feedRe: repmgr(d) versions 5.5 vs 5.4 from apt.postgresql.org
3+ messages / 3 participants
[nested] [flat]
* Re: repmgr(d) versions 5.5 vs 5.4 from apt.postgresql.org
@ 2024-12-24 13:29 Ron Johnson <[email protected]>
2024-12-24 14:04 ` Re: repmgr(d) versions 5.5 vs 5.4 from apt.postgresql.org Matthias Leisi <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Ron Johnson @ 2024-12-24 13:29 UTC (permalink / raw)
To: pgsql-general
On Tue, Dec 24, 2024 at 4:28 AM Matthias Leisi <[email protected]> wrote:
> I installed Postgres 16/17 from 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)
>
> I created the cluster with
>
> /usr/lib/postgresql/17/bin/repmgr -f /etc/postgresql/17/main/repmgr.conf
> primary register
>
> And it shows what I would expect:
>
> postgres@dev-pgcl01:~$ /usr/lib/postgresql/17/bin/repmgr -f
> /etc/postgresql/17/main/repmgr.conf cluster show
> DEBUG: connecting to: "user=repmgr connect_timeout=2 dbname=repmgr
> host=10.20.70.26 fallback_application_name=repmgr options=-csearch_path="
> DEBUG: connecting to: "user=repmgr connect_timeout=2 dbname=repmgr
> host=10.20.70.26 fallback_application_name=repmgr options=-csearch_path="
> ID | Name | Role | Status | Upstream | Location | Priority |
> Timeline | Connection string
>
> ----+-------+---------+-----------+----------+----------+----------+----------+----------------------------------------------------------------------------------------
> 1 | node1 | primary | * running | | default | 100 | 1
> | host=10.20.70.26 user=repmgr dbname=repmgr connect_timeout=2
>
>
> I attempt to start repmgrd with
>
> postgres@dev-pgcl01:~$ /usr/lib/postgresql/17/bin/repmgrd -v -f
> /etc/postgresql/17/main/repmgr.conf --verbose
>
> Which gives the following log output:
>
> [2024-12-24 09:21:25] [NOTICE] repmgrd (repmgrd 5.5.0) starting up
> [2024-12-24 09:21:25] [INFO] connecting to database "host=10.20.70.26
> user=repmgr dbname=repmgr connect_timeout=2"
> [2024-12-24 09:21:25] [DEBUG] connecting to: "user=repmgr
> connect_timeout=2 dbname=repmgr host=10.20.70.26
> fallback_application_name=repmgr options=-csearch_path="
> [2024-12-24 09:21:25] [DEBUG] set_config():
> SET synchronous_commit TO 'local'
> [2024-12-24 09:21:25] [DEBUG] expected extension version: 50500; extension
> version: 50400
> [2024-12-24 09:21:25] [ERROR] this "repmgr" version is newer than the
> installed "repmgr" extension version
> [2024-12-24 09:21:25] [DETAIL] "repmgr" version 5.5.0 providing extension
> version 5.5.0 is installed but extension is version 5.4
> [2024-12-24 09:21:25] [HINT] update the installed extension version by
> executing "ALTER EXTENSION repmgr UPDATE" in the repmgr database
>
>
> SELECT * FROM pg_catalog.pg_extension WHERE extname = 'repmgr'
>
> shows version 5.4
>
> 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?
>
This [HINT] says that YOU are supposed to run the ALTER EXTENSION command:
[quote]
update the installed extension version by executing "ALTER EXTENSION repmgr
UPDATE"
[/quote]
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: repmgr(d) versions 5.5 vs 5.4 from apt.postgresql.org
2024-12-24 13:29 Re: repmgr(d) versions 5.5 vs 5.4 from apt.postgresql.org Ron Johnson <[email protected]>
@ 2024-12-24 14:04 ` Matthias Leisi <[email protected]>
2024-12-24 16:12 ` Re: repmgr(d) versions 5.5 vs 5.4 from apt.postgresql.org Tom Lane <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Matthias Leisi @ 2024-12-24 14:04 UTC (permalink / raw)
To: pgsql-general
>
> This [HINT] says that YOU are supposed to run the ALTER EXTENSION command:
> [quote]
> update the installed extension version by executing "ALTER EXTENSION repmgr UPDATE"
> [/quote]
I did run that, but it seemed to have no effect. How should the update work, what should it do?
— Matthias
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: repmgr(d) versions 5.5 vs 5.4 from apt.postgresql.org
2024-12-24 13:29 Re: repmgr(d) versions 5.5 vs 5.4 from apt.postgresql.org Ron Johnson <[email protected]>
2024-12-24 14:04 ` Re: repmgr(d) versions 5.5 vs 5.4 from apt.postgresql.org Matthias Leisi <[email protected]>
@ 2024-12-24 16:12 ` Tom Lane <[email protected]>
0 siblings, 0 replies; 3+ messages in thread
From: Tom Lane @ 2024-12-24 16:12 UTC (permalink / raw)
To: Matthias Leisi <[email protected]>; +Cc: pgsql-general
Matthias Leisi <[email protected]> writes:
>> This [HINT] says that YOU are supposed to run the ALTER EXTENSION command:
> I did run that, but it seemed to have no effect. How should the update work, what should it do?
What this suggests is that you have a repmgr executable (.so file)
that is newer than the extension's SQL files
(.../share/extension/repmgr.control etc).
You need to straighten out that version mismatch.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-12-24 16:12 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-12-24 13:29 Re: repmgr(d) versions 5.5 vs 5.4 from apt.postgresql.org Ron Johnson <[email protected]>
2024-12-24 14:04 ` Matthias Leisi <[email protected]>
2024-12-24 16:12 ` Tom Lane <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox