These are a couple of tools that are commonly used with PostGIS for building mapping applications. Some of these we discuss in Chapter 11: Using PostGIS in Web applications
For PostGIS raster we developed a proof of concept ad-hoc viewer described in Minimalist Web Based PostGIS 2.0 Raster and Geometry viewer which you can download from: ASP.NET Version and PHP version