The popularity of something on HN vs popularity in general is not comparable, HN is only a small subset of the general developer population.
I might still use MySQL for future projects because I still have to know it and I already have it in use.
But if I instantly had no legacy to support and starting a new project, I wouldn't hesitate to use Postgres.