I've been working through the basics of Openstreetmap - trying to understand the data model, tags and the contribution workflow. I thought it would be useful to setup a locally-hosted dataset of OSM data to query, export and model. I could not find anything that was as "turn-key" simple as I wanted so I put one together. The result is a very basic (minimal) starting point but being defined in the scripts, it should be easy to extend.
All the code and scripts are in mikehiggins/osmpgsql