table missing in the postgresql database about tileserver HOT 10 CLOSED

Hi!

Wow, Map-Pi, that's cool 😄

The mz_transit_level column is added by this SQL file, which should have been run as part of perform-sql-updates.sh, when loading additional data as part of the install. Did you notice any errors when you ran that step?

It might be worth re-running that single SQL file (or the whole perform-sql-updates.sh, if the other additional columns are missing from other tables), using something like this:

psql -f apply-planet_osm_line.sql -d YOUR_DATABASE_NAME

Along with any additional psql parameters (users, passwords, etc...) that you might need for your local setup.

Hope that helps!

from tileserver.

thanks zerebubuth for your help, your command is working but now I have different errors when I start the script perform-sql-updates.sh.
for example I have the following error when updating the database : ERROR column "mz_poi_min_zoom" of relation "planet_osm_point" already exists
the matter is that the server return the same error as the one on my first post; but about mz_poi_min_zoom

from tileserver.

Ah. There's also a mz_poi_min_zoom in planet_osm_polygon, perhaps it's that one which is giving the error? Please try running:

psql -f apply-planet_osm_polygon.sql -d YOUR_DATABASE_NAME

And see if that fixes the problem.

from tileserver.

yes sorry to disturb you again , in fact I thinkthe first error is coming from the functions.sql file
ERROR: column "inception" does not exists

from tileserver.

That's odd... The inception column of the wof_neighbourhood table is added when the table is created. Are you using a particular version or tag of vector-datasource, or the master branch?

You could try running:

psql -c "DROP INDEX IF EXISTS wof_neighbourhood_label_position_index; DROP INDEX IF EXISTS wof_neighbourhood_min_zoom_index; DROP INDEX IF EXISTS wof_neighbourhood_max_zoom_index; DROP TABLE IF EXISTS wof_neighbourhood; DROP TABLE IF EXISTS wof_neighbourhood_placetype;" -d YOUR_DATABASE_NAME

That might print out a bunch of "does not exist" messages, which are safe to ignore. Then run:

psql -f wof_schema.sql -d YOUR_DATABASE_NAME

That should re-create the WOF tables, and when you verify them, they should have the inception column.

from tileserver.

The database was probably created from the snapshot that we have on s3. I bet that doesn't have the inception stuff in there. We should probably just put up a new snapshot, and automate creating it on a regular basis.

from tileserver.

@rmarianski that's a good point. I think you're right. I've added tilezen/vector-datasource#518 to track this and discuss what the appropriate solution is.

from tileserver.

@lechembal Can you confirm your configuration is working now, please?

from tileserver.

Hello,
It's Still not working, I am planning to restart all the configuration from
scratch.
I Will tell u this afternoon if it's working

Sincerely
Le 10 févr. 2016 20:12, "Nathaniel V. KELSO" [email protected] a
écrit :

@lechembal https://github.com/lechembal Can you confirm your
configuration is working now, please?

—
Reply to this email directly or view it on GitHub
#15 (comment).

from tileserver.

Closing this old issue as we think we fixed it. Please reopen or create a new issue if you run into the problem again.

from tileserver.