I'm looking for a self-maintaining, non-payware Linux. Actually, it doesn't necessarily need to be Linux at all, as long as it runs PostgreSQL and PHP in a stable manner.
Once installed, and PostgreSQL and PHP are on it, I want to never have to think about it existing again.
I want it to automatically detect, download and install any system patches and updates to the installed programs.
The only interaction I want to have with the machine is to SFTP into it, to transfer files to it, as if it were an account at some webhost rather than my own machine.
Some reasons for me wanting this are:
- Serious psychological stress/mental issues from 15+ years of babysitting servers.
- Lack of money and trust to pay for a "managed" server.
- Lack of trust to be able to pay for a webhost account. (Also, rarely any PostgreSQL support anyway, even if I could accept the risk.)
- Physical control.
- Several more practical issues which are important but hard to explain.
Even besides all those reasons, wouldn't anyone want this unless your hobby is specifically to use a computer for the sake of using a computer?
Please note that it doesn't count if there is some "optional mode" where it auto-updates, but which isn't reliable, and just breaks the server instead.
If this is still not available, what exactly is the reason for this, other than "we want it to be difficult" or "ensuring work for administrators"? I consciously kept the requirement extremely basic, and don't involve a million weird and exotic software. PHP and PostgreSQL. The two basic tools in my toolbox. Hammer and saw, basically.
Even just the stress alone from having to keep track of new updates/patches, and always be ready and able to log in and manually deal with it (what happens if I'm in an accident and wake up after an eight-month coma to find that my unpatched server is compromised?) would justify this a million times over in my mind. But coupled also with all the other reasons, such as people having no clue that you even need to update stuff (yes, this is really what the vast majority of people think about servers... myself included many years ago), I simply cannot understand how this is not a thing... if it isn't. It doesn't seem to be.
Please prove me wrong.
PS: I don't want to destroy this question by adding the further requirement that it has to run on my Raspberry Pi, but if it does, that is a huge bonus.