Maps and barcharts

Hi!
We have a lot of data in different formats (shapefiles, tables...). We want to 
move all this data to a database (read: PostGIS) in order to produce the sort 
of studies we have been producing so far with very labour intensive 
methods :)

So far, so good. PostGIS spatial queries are awesome, and coupled with Python, 
Matplotlib and LaTeX, I am producing very good looking reports. However, it 
is producing adding cartography to this mix. I have in the past used GMT for 
raster data, and I guess I could convert WellKnownText into something that 
GMT understands. However, there is a need to produce cartography with pie 
charts, bar charts and other stuff on them, something like what this image 
shows: <http://www.redcar-cleveland.gov.uk/YrCounc1.nsf/map-piecharts.gif> 
(this is just a random example found googling around). Even automatically 
producing simple maps of vector data coloured by attribute (with a nice 
legend, scale bar et al.) would be very helpful. 

Is there some FOSS framework to accomplish this task?

Many thanks,
Jose