July 15, 2019 at 8:28 pm
I would like to try to install SQL server and PostgreSQl on a linux system. It is a test environment
This is just for explore and learn linux and how to work with database.
What linux system do you recommend,
Redhat or ubuntu?
Thanks
July 16, 2019 at 9:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
July 16, 2019 at 9:29 pm
Which you use is really up to you. Just like an application that provides a service that others do, much of what you choose is down to preferance. Personally, I use Ubuntu, but that doesn't mean to say that's what you should choose.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 17, 2019 at 10:13 pm
They're roughly all the same. I find RHEL a bit more a pain since they ask for some registration stuff. I prefer Ubuntu for desktop level stuff.
July 17, 2019 at 10:16 pm
Thanks, I love ubuntu too for desktop.
But for this purpose, I am exploring for using it later in production database server.
Maybe this is more tendency to redhat.
July 17, 2019 at 10:29 pm
In that case, I'd use what you expect. The differences are really minor, but go with RHEL. I have RHEL and Ubuntu vms with SQL Server, the real difference is how you update things, yum v apt-get, but otherwise they're the same.
July 17, 2019 at 10:30 pm
Thanks much!
July 20, 2019 at 11:15 am
I believe the repositories tend to be more up to date on Ubuntu too but it depends if that matters.
I tend to prefer Ubuntu and am currently using it to power production SQL Server databases as well as MySQL databases and it runs .NET Core websites and PHP websites and has never given me any issues.
July 21, 2019 at 7:03 am
I also installed Postgres on Ubuntu in Dev manually. Worked pretty well. However our Engineering team is using Postgres installed on Centos 7 via puppet.
July 22, 2019 at 9:37 am
I don't pay attention to Linux distros much, and try not to be bleeding edge, so unaware of Ubuntu is better.
CENTOS is supposed to be RHEL minus support, correct? Isn't this the "community version of Redhat? I hope MS supports this, as it would be a nice way to get people on the desktop started. RHEL feels like VMWare. A lot of corporate registration and hassle.
July 22, 2019 at 3:50 pm
My network engineer installed Ubuntu for me, he said he installed the server version. He said REDHAT actually is not free.
Yes, I understand Centos is the free version of RHEL.
July 22, 2019 at 4:13 pm
Bugs me that the only "officially" supported version of Ubuntu for SQL Server is still 16.04. Although 16.04 itself is an LTS version, and supported until 2021, a lot of the distributions themselves, such as Kubuntu, Ubuntu Mate, etc, only offer 3 years of support on an LTS version; meaning that certain parts won't get patched by the distro team. I run all my SQL Server instances in containers on Ubuntu, so it's not a problem, but it is for some I'm sure.
I've not had any problems running SQL Server on 18.04 any more (it used to not work), but it would be nice to know it was supported on the latest LTS release, which has now been out for 15 months. You wouldn't expect for someone like Oracle to not support Windows 10 after it had been out for a year; so not sure why Microsoft aren't supporting the latest versions after they've had time to "bed in". :/
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply