Think GeoServer is able to output to KML and you can use PostGIS as a source for publishing to Google Earth ?