Are Psychology and Religion compatible concepts?

I spoke with a psychologist (not a psychiatrist!), and we touched upon the topic of religion. He told me that people mostly invent gods for comfort.

I don't know, OptiMAL, what made you decide to start comparing psychology and religion; I would rather advise you to study mathematical logic, so you wouldn't create such strange cause-and-effect relationships. If you meet an atheist geographer, will a topic appear on the forum about geography and religion being incompatible?
Just study logic, as well as psychology, using scientific sources, and not based on the words of a single individual who may have their own point of view on anything, including their profession.
Yes, and the Bible too... at least read the works of theologians before claiming that the biblical serpent and Satan are the same thing.
By the way, if your psychologist said that "people invent gods for comfort," this does not yet define religiosity as a mental disorder. The instinct of self-preservation is inherent in a mentally healthy person, and the desire to convince oneself that one can protect oneself from any evil, any misfortune, naturally follows from this instinct.
You know, few people can calmly accept that "...man is mortal, but that would be half the trouble. The problem is that he is sometimes suddenly mortal, and that's the catch! And he can't even say what he will be doing this evening." (c)

Added 14 minutes later

People who are possessed are considered insane and locked up in psychiatric hospitals. But when they bring some madman to a church and begin the exorcism rite, terrible things happen: for this person, holy water is like knives. Soon after this rite, when the demon leaves the body, the person becomes normal. This fact cannot be explained by psychology.

Have you personally ever seen an example of a successful exorcism attempt? Because physicists, for example, also cannot explain walking on water and turning water into wine... however, no one has personally seen these processes. And if you have to choose between religion and physics, the latter seems much more convincing to me.
By the way, what do you treat yourself with, if you don't mind me asking: medicine or religion? That is, pills or holy water?

This fact cannot be explained by psychology.

In fact, any doctor can explain this fact - the placebo effect, most likely.

People who are possessed are considered insane and locked up in psychiatric hospitals.

This is a very inaccurate statement. "People who are possessed" - are you sure they have a demon? It should be noted that "possession," as it is described, is usually epilepsy in its most typical clinical manifestations. The fact of epileptic brain damage is easily recorded on an electroencephalogram. But where is the evidence of the presence of a "demon" in a person? "They are locked up in psychiatric hospitals"? Epilepsy is more often treated on an outpatient basis, and it is definitely not a reason for placing a patient in a specialized closed institution.
And most importantly: epilepsy is not a mental, but a neurological disease. It is treated not by psychologists (who do not treat patients at all), not by psychiatrists, but by neurologists. So let's now expose neurology as an anti-religious science...