Render Database Load

Jump to bottom Edit New page

Tom Hughes edited this page May 23, 2019 · 29 revisions

Chef up server using the tile role if necessary
Download planet.pbf
Stop chef-client, apache2, renderd and replicate services
Ensure postgresql is allowing enough connections
Load planet with sudo -u tile osm2pgsql --slim --database=gis --cache=50000 --flat-nodes=/store/database/nodes --number-processes=N --multi-geometry --hstore --style=/srv/tile.openstreetmap.org/styles/default/openstreetmap-carto.style --tag-transform-script=/srv/tile.openstreetmap.org/styles/default/openstreetmap-carto.lua planet-latest.osm.pbf
Create additional indexes using /srv/tile.openstreetmap.org/styles/default/indexes.sql
Initialise replication - place sequence.txt from before planet in /var/lib/replicate and start the replicate service
Start renderd
Render low zoom tiles with render_list --all --force --tile-dir=/srv/tile.openstreetmap.org/tiles --socket=/var/run/renderd/renderd.sock --num-threads=N --max-load=70 --min-zoom=0 --max-zoom=10
Start apache2 and chef-client