manageiq icon indicating copy to clipboard operation
manageiq copied to clipboard

Support Postgres 15+

Open jrafanie opened this issue 1 year ago • 4 comments

Postgres 13 is EOL Nov 25, 2025 EDIT: rpms provided as part of red hat OS versions are supported much longer, especially one like PG 13 which was the default version in rhel 9. Even still, we need to update when we upgrade the OS.

High level: We need to get HA support which primarily involves repmgr compiled and built against postgres 15. We also need to test logical replication for region support. Both would need to be tested on appliances and new rpms delivered for upgrades.

We're using repmgr 5.2.1, implemented in: https://github.com/ManageIQ/manageiq-rpm_build/pull/309 https://github.com/ManageIQ/manageiq-rpm_build/pull/341 https://github.com/ManageIQ/manageiq-rpm_build/pull/443

It's currently at version 5.4.1 and supports postgres 16: https://www.repmgr.org/docs/current/index.html

5.3.0 supports PG 14 https://www.repmgr.org/docs/current/release-5.3.0.html 5.3.3 supports PG 15 https://www.repmgr.org/docs/current/release-5.3.3.html

jrafanie avatar Sep 24 '24 14:09 jrafanie

This issue has been automatically marked as stale because it has not been updated for at least 3 months.

If you can still reproduce this issue on the current release or on master, please reply with all of the information you have about it in order to keep the issue open.

miq-bot avatar Jan 06 '25 00:01 miq-bot

CentOS Stream 10 is released with PostgreSQL 16, so we should probably target that.

bdunne avatar Jan 06 '25 20:01 bdunne

This issue has been automatically marked as stale because it has not been updated for at least 3 months.

If you can still reproduce this issue on the current release or on master, please reply with all of the information you have about it in order to keep the issue open.

miq-bot avatar Apr 14 '25 00:04 miq-bot

This issue has been automatically marked as stale because it has not been updated for at least 3 months.

If you can still reproduce this issue on the current release or on master, please reply with all of the information you have about it in order to keep the issue open.

miq-bot avatar Jul 21 '25 00:07 miq-bot