How do I connect Google Earth with any relation database? I have live database containing spatial co-ordinates i.e latitude and longitude. User should be able to view these live data on google earth.
If you want to serve the data as static KML, the easiest option is to use ST_AsKML function in PostGIS. However if you want to use live KML data, one option could be using GeoServer and get the output in KML format.