[Geocoding] Help with an error where "planet_osm_nodes" doesn't exist

Charles Randall crandall747 at gmail.com
Thu Oct 11 22:52:32 BST 2012


I'll give that a shot - thank you.
Quick question - does the first ./utils/setup.php --all also need an xml
file only or is pbf ok for it (I assume the latter but thought I'd ask).

Thanks again,
Charles.

On Thu, Oct 11, 2012 at 2:27 PM, Sarah Hoffmann <lonvia at denofr.de> wrote:

> On Thu, Oct 11, 2012 at 01:53:01PM -0700, Charles Randall wrote:
> > 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?
>
> It looks like you run ./utils/setup.php --import-data on this DB which
> unfortunally destroyed the data that you had already imported. So, you
> will have to start over again.
>
> Run ./utils/setup.php --all ... with the first file, then
> ./utils/update --import-file with any further osm files (these must
> be in xml format, not in pbf) and finally ./utils/update --index.
>
> Sarah
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/geocoding/attachments/20121011/7f201616/attachment.html>


More information about the Geocoding mailing list