Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Latest post by 0dries on Monday, 18 December 2023 08:33 CST
Hi,
I was exploring Joomla! 5.
On siteground.com, only MySql 5.7 is supported (and not even the latest minor increment of that). They have no concrete plans to move up to the latest LTS. But they seem to offer a recent enough PostGres version (my site needs to be moved to another shared server, so I can't tell for sure yet).
Now, I just read that the backup tool has no support for PostGres. That's a bummer. Are there any plans to do so in some near future?
KR,
Dries.
We had PostgreSQL support, but we removed it. There were several problems, all of which having to do with the fact that PostgreSQL does not allow you to dump the structure of a table in a way that makes it fully reproducible on a new server. We did our best, but the dump could never be 100% complete, causing various issues in edge cases we could not catch – and there were some edge cases we could catch but not do anything about. Between that and the virtually non-existent support for PostgreSQL across third party Joomla! extensions there was no reason to continue supporting it.
Even if we supported PostgreSQL, you'd have to rebuild all of your sites FROM SCRATCH. There is no reasonable way to convert a site built on MySQL / MariaDB to use PostgreSQL, which is undoubtedly what you had in mind with your question. Therefore, you can't even transfer data; you will have to manually copy everything from the old MySQL-based site to the new PostgreSQL-based site, item by item, after rebuilding the site from scratch. Nobody will pay you to do that; that's building a new site from scratch, plus all of the associated data entry.
Moreover, as I explained above, the vast majority of third party extensions does not support PostgreSQL. This means that you'd have to rebuild your sites from scratch, without using third party extensions.
In my professional opinion, it is far less problematic and far more expedient moving your sites to a different host.
This might actually be a good idea anyway, since SiteGround has just told you and everyone else that they are not to be relied upon to provide a secure hosting environment. MySQL 5.7 is End of Life since October 25th, 2023 and no longer receives security updates. This makes it unfit for use in production, yet SiteGround has announced it will do exactly that for the foreseeable future!
Nicholas K. Dionysopoulos
Lead Developer and Director
🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!
Thanks for this. I have no experience with PostgreSQL, I naively assumed that it would be interchangeable with MySql for the bulk of the extensions. I'll have to check the all carefully.
As for Siteground, well, it is a massive step-up from my previous hosting. I'm a bit surprised their tooling versions aren't on par with their ease of use and their support. Still, time to compare again, it seems.
Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.
Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!