PostGIS is now basically the "industry standard", so most third party tools work with it, even Esri! Here's some open source parts:
Desktop: https://qgis.org
Middleware: https://mapserver.org, https://geoserver.org, https://mapnik.org, https://github.com/crunchydata/pg_tileserv, https://github.com/crunchydata/pg_featureserv
Web UI: https://openlayers.org, https://leaflet.org, https://www.mapbox.com/mapbox-gljs