And even for PHP apps like MediaWiki that do support PostgreSQL the primary development target is still MySQL.

So it's not worth the trouble to use PostgreSQL in most cases, you'll eventually want to install some extension that only supports MySQL, or get tired of reading documentation that assumes MySQL etc.