I'm trying to render tiles out of a KML file. Normally, I'd render tiles out of an planet.osm extract. For example, I'd select a tag using osmosis and then process it with osm2pgsql. Then I'd generate the tiles using Mapnik's python script and I'd serve them with OpenLayers.
Maintaining this structure, i.e. PostgreSQL (with PostGIS) and OpenLayers, I'd like to know what's the best way to do this starting from a kml file, rather than an osm one. An option would be to transform the kml file into an osm file. Another option would be to find something like kml2pgsql. I haven't found any questions nor ways to do this (I'm specially surprised this is not a duplicated question).
Do you know how to do this? (might be using something else, as far as it's supported in Linux and uses Postgresql - Openlayers).
Answer: I marked Andre answer as the final one because while I'm not using exactly what he said it put me in the right path. I ended up using TileMill rather than QGIS, but the process is practically the same...