Postgre would replace SQL Server in most case where just a database is required.
However, a SQL server license covers Integration Services, Analysis Services, Report Services and other stuff as a (mostly) integrated suite as long as you run them on one box (which is really a RAM question).
I’m 100% a Postgre supporter but SQL Server has its place.