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.org/thread/MVHR5WZFEDOZA4ESBN5764EVP67GKOS5/

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.html 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


--

Best Regards,

Jiatong Shen