[Geocoding] [Resend: sorry if this came twice] - Help with an error where "planet_osm_nodes" doesn't exist

Charles Randall crandall747 at gmail.com
Thu Oct 11 21:53:01 BST 2012


I've setup Nominatim on Centos 5 (64 bit) and went ahead and imported a
city streetmap file (using ./utils/setup.php --osm-file <file> --all).
Now I'm trying to install a second osm file.

I run :
./utils.update.php --import-file <filename>

I get the following error:

/home/palantir/Nominatim/
osm2pgsql/osm2pgsql -klas -C 2000 -O
gazetteer -d nominatim /home/palantir/Nominatim/data/osmosischange.osc
Using projection SRS 4326 (Latlong)
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=2000MB, maxblocks=256001*8192, allocation method=11
Mid: pgsql, scale=10000000 cache=2000
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
osm2pgsql exited with error level 1


I checked postgres and I don't have a planet_osm_nodes table. I assumed
this would have been setup by the setup.php --all command but that didnt
work. I've run setup.php with the --create-tables option but no dice.
Any idea whats up and how I can work around this?

Thanks

Charles.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/geocoding/attachments/20121011/1b6ecbf3/attachment.html>


More information about the Geocoding mailing list