NOTICE: is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

Hello I have installed a tile server on my local Ubuntu 12.04 server. I've used this I have slippymap working, it shows only my country, so it is ok. Then I've installed nominatim, it is also ok. Then the Rails Port, that includes Potlatch2 inside. Rails port works fine, i've registered potlatch and now I can make changes to the map, put an object for exaple. When I press "Save" - Potlatch says 'Saved'. And I see my changes when I load Potlatch again. But I don't see any changes on my slippymap. So the tiles are the same. How can I detect where the problem is? To what db does potlatch write? When re-rendering should happen? Thanks in advance=)

asked 18 Feb '13, 15:43

Alex_Z's gravatar image

accept rate: 0%

I have one more idea. There is a place in Rails port install, that I don't understand quite well.


To populate a PostgreSQL database using Osmosis from a planet file, do this: osmosis --read-xml-0.6 file="planet.osm.bz2" --write-apidb-0.6 populateCurrentTables=yes host="localhost" database="openstreetmap" user="openstreetmap" password="openstreetmap" validateSchemaVersion=no

Later updates to the database (sometimes referred to as the apidb) will need to use a change format (.osc).

You will need the latest Osmosis to have the right database scheme.

Troubleshooting database population
Running causes the error "Unable to create streaming resultset"

Run osmosis on the database "openstreetmap", e.g. use the command osmosis --rx file="planet.osm" --wd database="openstreetmap" user="openstreetmap" password="openstreetmap" Running causes the error "The database schema version of $1 does not match the expected version of $2"

Assuming that you are using osmosis with the 0.6 db, you can just add validateSchemaVersion=no to the --write-apidb params. Configuring Database to Write

If you intend to write to your database, you will need to reset the auto-increment sequences first (within postgres).

Note: Do this sequence twice, once for openstreetmap, once for osm.

I did not run this, as the idea is not clear for me. Can it be the root of my problem?

(21 Feb '13, 11:57) Alex_Z

Ok, I've made this steps

1.sudo ./osmosis -q --replicate-apidb authFile=~osmosis/authFile.conf allowIncorrectSchemaVersion=true validateSchemaVersion=no --wr workingDirectory=/var/www/replication

2. ./osmosis --read-replication-interval workingDirectory=~/.osmosis/ --simplify-change --write-xml-change ~/.osmosis/changes.osc.gz

I can see my changes in xml format inside this file

  1. osm2pgsql --append --slim changes.osc.gz

But I'm getting an error

:~/OSMOSIS/osmosis-0.41/bin$ osm2pgsql --append --slim .osmosis/changes.osc.gz osm2pgsql SVN version 0.81.0 (64bit id space)

Using projection SRS 900913 (Spherical Mercator) Setting up table: planet_osm_point NOTICE: table "planet_osm_point_tmp" does not exist, skipping Setting up table: planet_osm_line NOTICE: table "planet_osm_line_tmp" does not exist, skipping Setting up table: planet_osm_polygon NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping Setting up table: planet_osm_roads NOTICE: table "planet_osm_roads_tmp" does not exist, skipping Allocating memory for dense node cache Allocating dense node cache in one big chunk Allocating memory for sparse node cache Sharing dense sparse Node-cache: cache=800MB, maxblocks=102401*8192, allocation method=11 Mid: pgsql, scale=100 cache=800 Setting up table: planet_osm_nodes PREPARE insert_node (int8, int4, int4, text[]) AS INSERT INTO planet_osm_nodes VALUES ($1,$2,$3,$4); PREPARE get_node (int8) AS SELECT lat,lon,tags FROM planet_osm_nodes WHERE id = $1 LIMIT 1; PREPARE delete_node (int8) AS DELETE FROM planet_osm_nodes WHERE id = $1; failed: ERROR: relation "planet_osm_nodes" does not exist LINE 1: ...rt_node (int8, int4, int4, text[]) AS INSERT INTO planet_osm... ^

Error occurred, cleaning up

There is really no table "planet_osm_nodes" in "gis" schema. Should it be there?

(22 Feb '13, 16:13) Alex_Z

Check that renderd is running on your machine (probably should add it to startup scripts) and configured correctly.

permanent link

answered 18 Feb '13, 16:14

gormo's gravatar image

accept rate: 13%

renederd feels good, the problem is not here (

(18 Feb '13, 16:19) Alex_Z

I am sorry to ask you question here.But could you tell me how did you sovle that problem,I really need your help. Thanks very much.

(24 Nov '17, 11:07) gleide

If you have two databases or database schemas (one for editing and one for rendering) then you need to setup a tool chain to propagate the changes from the edit-db to the render-db.

permanent link

answered 21 Feb '13, 17:25

mmehl's gravatar image

accept rate: 15%


Thanks, links seem to be useful. But can I use just one schema both for rendering and editing?

(21 Feb '13, 18:45) Alex_Z

Nobody has created a tool (yet) to render directly from the apidb schema. The two schemes are very different, as they have different requirements.

(21 Feb '13, 20:45) cartinus

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 18 Feb '13, 15:43

question was seen: 6,463 times

last updated: 24 Nov '17, 11:07

NOTICE: is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum