On Fri, 5 Dec 2025, 03:25 Sa Pham, <saphi070@gmail.com> wrote:
HI Artem,
Could you share why you run Keystone with Postgresql ?
I'm running Keystone with Postgresql as well, because my other application is using Postgresql so I don't want to deploy two Database servers. And it's working well without issue.
It is more or less a personal preference after working professionally for decades with both databases. Postgres features remind me more other major relational databases, while MySQL goes "own way". It's not about certain needs of Keystone, this is just a personal preference.
On Thu, Dec 4, 2025 at 11:10 PM Artem Goncharov <artem.goncharov@gmail.com> wrote:
In my local tests I always use postgres for Keystone (as well in the keystone-ng testing) and it works. But I agree we do not have dedicated tests as of now, so some edge cases may be broken
On Thu, 4 Dec 2025 at 16:37, Sean Mooney <smooney@redhat.com> wrote:
nova does not have tempet/devstack jobs either however we never officially deprecated or removed support for PostgreSQL
we still test it in our unit tests to ensure the schema applies and some other minor test coverage but its also been a few years since there was any real end to end testing.
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
On 04/12/2025 14:36, Julia Kreger wrote: 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
-- Sa Pham Dang Skype: great_bn Phone/Telegram: 0986.849.582