Re: repmgr(d) versions 5.5 vs 5.4 from apt.postgresql.org

2024-12-24 Thread Matthias Leisi
> > 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? — Matthia

repmgr(d) versions 5.5 vs 5.4 from apt.postgresql.org

2024-12-24 Thread Matthias Leisi
ng "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

Database schema for "custom fields"

2024-09-09 Thread Matthias Leisi
other options? Thanks for your insights, — Matthias -- Matthias Leisi Katzenrütistrasse 68, 8153 Rümlang Mobile +41 79 377 04 43 matth...@leisi.net

Cluster for an appliance-type deployment

2023-11-06 Thread Matthias Leisi
Dear all, I’m reasonably experienced with Postgres with simple (single, „rebuild and restore“) requirements, but would need some hints on what to look for in a more complex situation - deploying Postgres as the backend for a (virtual) appliance. This appliance can scale horizontally from a si