Page MenuHomePhabricator

Populate geoshapes reference database on the beta cluster
Closed, ResolvedPublic

Description

The geoshapes database is missing important tables on the beta cluster, which causes ExternalData support to fail to load. This prevents demonstrating some new geoshapes features such as geopoints.

Import a limited amount of reference data, like T305845 but on the beta maps server.

Event Timeline

Had to add a line to /usr/local/bin/maps-grants-gis.sql,

GRANT CREATE ON database gis to osmimporter;

From the shell,

wget http://download.geofabrik.de/europe/monaco-latest.osm.pbf

cat /usr/local/bin/maps-grants-gis.sql | sudo -u postgres psql -d gis -f -
sudo chgrp -R osm /srv/osm/
sudo find /srv/osm/ -type d -exec chmod g+w {} \;
sudo -u osmimporter imposm import -config /etc/imposm/imposm_config.json -mapping /etc/imposm/imposm_mapping.yml -overwritecache -read /home/awight/monaco-latest.osm.pbf -diff -write

The process seemed to go well, but I still don't see the required tables in the gis public schema.

Change 803932 had a related patch set uploaded (by Awight; author: Awight):

[operations/mediawiki-config@master] [beta] Switch maps rendering to the beta cluster

https://gerrit.wikimedia.org/r/803932

Change 803932 merged by jenkins-bot:

[operations/mediawiki-config@master] [beta] Switch maps rendering to the beta cluster

https://gerrit.wikimedia.org/r/803932

Works now, after a lot of support from @MSantos !

awight renamed this task from Populate maps reference data on the beta cluster to Populate geoshapes reference database on the beta cluster.Jul 20 2022, 10:55 AM