[OSM-dev] Best way to render tiles with apidb changes?

[Andy Allan]

On Sat, Sep 24, 2011 at 5:21 PM, Евгений Фарфель <jenfa at jenfa.od.ua> wrote:
> Hello!
>
> I am currently setting up local openstreetmap server (Rails port, tile
> renderer and Postgres API DB). So far I have a working rails port
> installation and able to submit changesets into apidb, they are
> working as expected. However, if I understand correctly, those
> changesets will not be visible on tiles rendered by Mapnik, because
> Mapnik uses separate database schema, am I right? So, what is the
> correct way to present apidb changes on Mapnik tiles? Or, maybe, I
> should not use Mapnik at all?

The best thing to do is to set up a minutely mapnik server. This uses
all the standard software so no coding is needed. When you have the
mapnik+postgis+osm2pgsql+mod_tile server set up, you can then export
the minutely diff files from the apidb using osmosis, and import the
diff files into the mapnik database. Instructions are at
http://wiki.openstreetmap.org/wiki/Minutely_Mapnik

I've set up both the apidb and the mapnik db on the same machine many
times, it works very well. Although it can be tempting to try setting
up something to read the apidb directly, having two databases and the
standard api replication system is much more robust and well tested.

Cheers,
Andy