using postgresql in production
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
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
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? 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
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
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
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. On 04/12/2025 14:36, Julia Kreger 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 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
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.
On 04/12/2025 14:36, Julia Kreger 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 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
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. 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.
On 04/12/2025 14:36, Julia Kreger 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 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
-- Sa Pham Dang Skype: great_bn Phone/Telegram: 0986.849.582
participants (7)
-
Artem Goncharov
-
Jiatong Shen
-
Julia Kreger
-
Maksim Malchuk
-
Sa Pham
-
Sean Mooney
-
Slawek Kaplonski