Greetings, Ironic ended up removing CI jobs for postgres back in 2024[0] when keystone merged postgres incompatible changes which broke the CI job and rendered it impossible to test. Previous to that, I think in 2023 or 2022, neutron made some changes but quickly fixed the breaking changes once they were highlighted. The linked change has some back and forth and the mailing list post[1] which spawned job removal from Ironic. Ultimately, while people have expressed interest, that has never really materialized into action or engagement to keep postgres support in a known working state. Unfortunately slight schema and behavior differences between the two database platforms really forces the need to perform that level of testing as well, which means one is likely to encounter issues if they just try to create and use a service's database in postgres at this point. Hope this has helped. -Julia [0]: https://review.opendev.org/c/openstack/ironic/+/931055 [1]: https://lists.openstack.org/archives/list/openstack-discuss@lists.openstack.... On Thu, Dec 4, 2025 at 3:32 AM Slawek Kaplonski <skaplons@redhat.com> wrote:
Hi,
Dnia czwartek, 4 grudnia 2025 11:15:55 czas środkowoeuropejski standardowy Maksim Malchuk pisze:
Hi Slawek,
I remember some presentations from the summit years ago but can't find them. Do you have any links about this information? Maybe docs or gerrit commits?
I only got https://governance.openstack.org/tc/resolutions/20170613-postgresql-status.h... and I remember we have discussed that few cycles back in the Neutron room during the PTG. I don't remember exactly which PTG it was however
On Thu, Dec 4, 2025 at 11:49 AM Slawek Kaplonski <skaplons@redhat.com> wrote:
Hi,
Dnia czwartek, 4 grudnia 2025 08:26:17 czas środkowoeuropejski standardowy Jiatong Shen pisze:
Hello community,
We are analyzing the possibility of using PostgreSQL in production. The reason behind is that the PostgreSQL community is very open and growing fast, besides many Chinese companies provide PG compatibility.
My question is what are the pros and cons between using PG and MariaDB. Are there any tools available to do online data migration for legacy environments? Any insight is deeply appreciated. Thank you. --
Best Regards,
Jiatong Shen
It may be hard as some time ago at least some projects like e.g. Neutron stopped testing and supporting Postrgesql officially. So you may expect some issues there I believe.
-- Slawek Kaplonski Principal Software Engineer Red Hat
-- Regards, Maksim Malchuk
-- Slawek Kaplonski Principal Software Engineer Red Hat