Hi Julia, Thank you for the information. The attachments in the given CI URL seem to be gone. Do you remember the details of the issue that broke the pipeline? Recently I am experimenting using PG for a Victoria OpenStack and it seems to be working fine, the experiment is still in the early stages and a lot of details might be missing. Do you remember the PR that introduces the compatibility issue? Thank you. Best regards, Norman Shen On Thu, Dec 4, 2025 at 10:36 PM Julia Kreger <juliaashleykreger@gmail.com> wrote:
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
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
standardowy Maksim Malchuk pisze: 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
-- Best Regards, Jiatong Shen