Which OS do you think is best?

Question

linux

I have a server on CentOS 6 with PostgreSQL 9 on board, with a bunch of databases with which the 1C server is actively working.
And then a server fell into my hands, better than what is now, and I realized that it was time, it was time to transfer databases to PostgreSQL fresher, but I still can’t decide on the OS.
Previously, I always chose CentOS as a server OS, but given the fact that they switched to rolling releases, using it as a server OS is no longer necessary.
Ubuntu has not been used for a very long time. How is she behaving now? Purely subjective opinion, some kind of exclusively snap packages, YUML for customization? Or have I formed completely wrong prejudices?
Rocky linux is sort of like a successor to CentOS, but confuses the distro's youth.
Of course, you can use Centos 7, but will its support period also end sooner or later?

Answer 1

wrong prejudices
Choosing linux by itself is not even discussed here.
If you have your own setup specialist (or you yourself are one), then you need to choose the OS according to what you understand better.
If we talk about what kind of choice should be not the system of the second level of support, but the first, on the basis of which these distributions are created, i.e. not ubuntu but debian.
Release version fixing is available in many operating systems, even gentoo can choose a 'stable' branch (as a joke, because a release in gentoo is like a test branch in debian or even newer).

Answer 2

Debian is stable and predictable. Lots of manuals, good wiki documentation https://wiki.debian.org/FrontPage , regular updates, long term LTS support.
The stable release package base may seem slightly outdated, but if you really need, the same PostgreSQL can be installed from the official repository https://www.postgresql.org/download/linux/debian/ ;)
Debian has a convenient installer that supports graphical and text modes, with more room for configuration during installation in Expert install mode.

Answer 3

If you worked with Centos all the way, then why bother to rock the boat somewhere else?
Switch to RHEL 8 in two ways:
1. Pay honestly for a license because you have a commercial project
2. You pretend to be a developer and you can use up to 16 free licenses (from a moral point of view, it’s not good to do this)

Answer 4

Or what you know, centOS
Or debian

Answer 5

Oracle Linux
Fully compatible with RHEL\Centos, free to use.
https://linux.oracle.com/switch/centos/

Answer 6

debian if you don't need the latest software.
Ubuntu is also a good option, the only thing that confuses me about it is that it often updates the kernel and asks for reboot after installation.