What makes Postgres unfit for that use? It doesn't have large licensing fees like SQL Server, and Postgres (just like MySQL) can run on a single node and handle small amounts of data just fine.
And I say this as somebody who defaults to postgres or sqlite over mysql where possible these days just because I expect it to be less of a headache down the road.