[OSM-dev] Nominatim installation "Please use a database without intarray"

Philippe DAVID philippe.david at allgoob.com
Tue Aug 16 09:23:20 BST 2011


>From what I understand, the wiki should be updated with the following line
remove:
cat /usr/share/postgresql/8.4/contrib/_int.sql | psql gazetteer

I am correct ?

On Tue, Aug 16, 2011 at 10:17 AM, Philippe DAVID <philippe.david at allgoob.com
> wrote:

> Ok sorry about this post, I just found this is duplicate of a recent
> discussion.
> When following the instructions, with ubuntu 11.04 the command I needed
> was
> sudo -u postgres psql gazetteer <
> /usr/share/postgresql/8.4/contrib/uninstall__int.sql
>
> Cheers,
> Philippe
>
> On Tue, Aug 16, 2011 at 10:06 AM, Philippe DAVID <
> philippe.david at allgoob.com> wrote:
>
>> Hi devs,
>> I'm trying to setup a nominatim instance by folowing the instructions from
>> the wiki http://wiki.openstreetmap.org/wiki/Nominatim/Installation
>>
>> When I launch osm2pgsql, it complains about the 'intarray' module begin
>> loaded. I am a complete posgresql begginer (although fluent with mysql) so I
>> tried to google about this but I found nothing conclusive.
>> I would welcome some help about this :)
>>
>> Here is the complete message. I work on ubuntu 11.04, postgresql 8.4 stock
>> install:
>> ###############
>> $ svn.openstreetmap.org/applications/utils/export/osm2pgsql/osm2pgsql-lsc -O gazetteer -C 2000 -d gazetteer france.osm
>> osm2pgsql SVN version 0.80.0 (32bit id space)
>>
>> Using projection SRS 4326 (Latlong)
>> NOTICE:  la table « place » n'existe pas, poursuite du traitement
>> NOTICE:  le type « keyvalue » n'existe pas, poursuite du traitement
>> NOTICE:  le type « wordscore » n'existe pas, poursuite du traitement
>> NOTICE:  le type « stringlanguagetype » n'existe pas, poursuite du
>> traitement
>> NOTICE:  le type « keyvaluetype » n'existe pas, poursuite du traitement
>> NOTICE:  la fonction get_connected_ways(pg_catalog.int4[]) n'existe pas,
>> poursuite du traitement
>> Mid: pgsql, scale=10000000, cache=2000MB, maxblocks=256001*8192
>> Setting up table: planet_osm_nodes
>>
>> The target database has the intarray contrib module loaded.
>> While required for earlier versions of osm2pgsql, intarray
>> is now unnecessary and will interfere with osm2pgsql's array
>> handling. Please use a database without intarray.
>>
>>
>> Error occurred, cleaning up
>> ###############
>>
>> Thanks,
>> Philippe
>>
>
>
>
> --
> Philippe
> Allgoob SA
>
>


-- 
Philippe
Allgoob SA
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20110816/004d351b/attachment.html>


More information about the dev mailing list