[liftbigweights]

> Slightly off-topic, but: has PostgreSQL largely replaced MySQL for new projects? I'm seeing larger numbers of positions advertising for Postgres, even here in the Midwest.

Perhaps, but I suspect people who are migrating from mysql are moving to mariadb, not postresql.

> Postgres seems so chock-full of features now

Now? PostgreSQL has always been more feature-rich ( especially compared to mysql ). What made mysql popular was it's lack of features ( simplicity ) and its tie-in with php/etc web development. Web developers loved mysql because it was simple and easier to manage because it was so feature poor. Give credit where it is due. MySQL really rode the web development momentum. But PostgreSQL has always been the more mature RDBMS.

This is a basic features list ( maybe somewhat biased and somewhat dated ) but the overall trend still holds today.

http://www.postgresqltutorial.com/postgresql-vs-mysql/

[MisterOctober]

Postgres has really picked up steam with enterprise and institutional users in my neck of the woods also [southwestern US]. The emphasis on role-based security and, lately, the ability to handle JSON, geolocation data, etc [plus finally getting some overdue query features like ROLLUP] have made some folks who previously swore by SQL Server or Oracle take it more seriously as an option for inhouse systems.

I see a fair number of local job postings that specify Postgres experience.

[snaky]

Yes, the most of migrations to PostgreSQL is not from MySQL, but from Oracle.