This is a static archive of our old OSM Help Site. Please post any new questions and answers at community.openstreetmap.org.

“moving” nominatim db to another machine (avoiding to repeat the indexing process)

0

Hi guys and thank you in advance

I have a virtual machine with nominatim and Italian map (about 1gb I don't remember). Now I would like to provide this service to another machine (with no big requirements..) and to avoid the indexing process, I was thinking of install nominatim on their machine and move (copy) the postgres data folder to their postgres Installation. Do you think can it work??

Thanks a lot

Confirmed!!

Sorry if I edit my post so late but I have tried this procedure and it worked perfectly with montecarlo map.

I dump my postgres db (db where I indexed the map) with this command:

 pg_dump nominatim > <folder>/dump.sql

Now put this file in the clean machine where you want replicate the service - follow the wiki.guide untill nominatim installation then create nominatim database with command:

CREATE DATABASE nominatim OWNER <user>

Instead of web user create directly apache user (on centos 6.6) with command:

 createuser -SDR apache

execute the db restore with command:

 psql -d nominatim -f dump.sql

resume the wiki.guide at paragraph "Install service on http" and "iptable configuration"

And thats it!! Maybe could help someone Bye

asked 11 Dec '15, 14:44

developer_afbnet's gravatar image

developer_af...
26335
accept rate: 0%

edited 13 Jan '16, 16:01