> Postgres isn’t in any sense struggling to attract new users – there are plenty of 22 year olds defaulting to it today.

Yes, I do use Postgres for a lot of my self-hosted apps. For PHP applications, though, I keep using MariaDB as their default/only DB.