Why do databases not administrate themselves?
You have to keep in kind that the user always knows more than the database engine itself. In addition to that, the administrator has access to a lot of external information about the operating system, hardware, user patterns, and all that. A database engine cannot decide whether a user's query is pointless or not – it does not know its purpose. Therefore, administrators and developers are always at an advantage over the database and are, therefore, necessary (and most likely always will be).
Does PostgreSQL face corruption often?
No. My company provides services for thousands of businesses. We rarely see cases of database corruption – and if there is corruption, it is usually caused by hardware issues.
Does PostgreSQL need constant care?
Usually not, unless you are using the database in a suboptimal way...
