I wrote a long-ish post on my personal blog about how I used osm2pgsql to set up and maintain the database that powers Resto-Bot, the silly bot that toots out an OSM restaurant feature that has not been updated in more than 5 years.