Was using MySQL for some time as I really did not look closely at all available. Started a deeper look when the native connector had beginnings of problems. Had been testing with other DB’s for answers on this site and chose PostgreSQL because of many features you don’t find all in another single DB. It also has a container for actual multiple DB’s and each having it’s own schema. This is not true in say MySQL where what you may think are different DB’s are actually just schema within.
PostgreSQL has been around for decades and appears to have much support. No, not trying to sell PostgreSQL to anyone - each must choose based on needs and ability.
This site has numerous howtos. Problem is finding them. Search capability is limited and the structure questionable. You can always ask a new question even if the answer is just a link to another answer.