[Geocoding] Nominatim data import error: DB Error: connect failed

[Nyx]

I've fixed the path issues above. I've also changed to importing a .bz2
instead of a .pbf as the .pdf is being read as an empty document.

Now I'm getting the following error:

Allocating memory for dense node cache
Allocating dense node cache in block sized chunks
Node-cache: cache=0MB, maxblocks=0*1, allocation method=8192
Mid: pgsql, scale=10000000 cache=0
Setting up table: planet_osm_nodes
NOTICE:  table "planet_osm_nodes" does not exist, skipping
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"planet_osm_nodes_pkey" for table "planet_osm_nodes"
Setting up table: planet_osm_ways
NOTICE:  table "planet_osm_ways" does not exist, skipping
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"planet_osm_ways_pkey" for table "planet_osm_ways"
Setting up table: planet_osm_rels
NOTICE:  table "planet_osm_rels" does not exist, skipping
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"planet_osm_rels_pkey" for table "planet_osm_rels"

Reading in file: /home/myusername/Nominatim/utils/us-northeast.osm.bz2
Segmentation fault

----

I tried redownloading the file but it seems to give the same error.




On Thu, Sep 13, 2012 at 9:28 AM, Nyx <nyxynyx at gmail.com> wrote:

> I am now getting the error:
>
> Create DB
> Setup DB
> unable to find /usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql
>
> ----
>
> I looked into setup.php and see the line
>
> pgsqlRunScriptFile(CONST_Path_Postgresql_Postgis.'/postgis.sql');
>
> This is probably what's defining
> `/usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql`. However I
> believe I have postgis 2 installed (yum list
> postgis2*). /usr/share/postgresql/ does not exist. How should this link be
> fixed? Thank you once again! :)
>
>
> On Wed, Sep 12, 2012 at 6:18 PM, Sarah Hoffmann <lonvia at denofr.de> wrote:
>
>> On Wed, Sep 12, 2012 at 04:51:05PM -0400, Nyx wrote:
>> > I tried commenting out the line `passthru('createlang plpgsql
>> > '.$aDSNInfo['database']);`. When I run the import command, I get the
>> ouput:
>> >
>> > Create DB
>> > Setup DB
>> > unable to start pgsql
>> >
>> > ----
>> >
>> > When I tried running `psql -p 5432 -d nominatim` I am able to connect to
>> > the database `nominatim`.
>>
>> If that works from the command line then the only other thing I could
>> think
>> of is that your php configuration does not allow psql to be executed or
>> cannot
>> find it. Also the script writes to /dev/null. Make sure that your user and
>> php are allowed to do that.
>>
>> > However when I check the contents of the database `nominatim`, I still
>> do
>> > not see anything added to the table.
>>
>> That is normal because the setup process dies before doing anything
>> useful.
>>
>> Sarah
>>
>>
>> >
>> > On Wed, Sep 12, 2012 at 12:17 PM, Sarah Hoffmann <lonvia at denofr.de>
>> wrote:
>> >
>> > > On Wed, Sep 12, 2012 at 03:46:47PM +0200, Frederik Ramm wrote:
>> > > > Hi,
>> > > >
>> > > > On 09/12/12 15:34, Nyx wrote:
>> > > > >Hi, thanks for the help so far. Some how I manage to get past that
>> > > > >error. Now when doing the import command, I get:
>> > > > >
>> > > > >Create DB
>> > > > >Setup DB
>> > > > >createlang: language "plpgsql" is already installed in database
>> > > "nominatim"
>> > > >
>> > > > 9.x versions of PostgreSQL have plpgsql activated by default. I
>> > > > don't know if that is a problem but maybe you should comment out the
>> > > > line that executes the "createlang" command.
>> > >
>> > > This error can be ignored. The setup actually went past it. The
>> interesting
>> > > error was this one:
>> > >
>> > > > unable to start pgsql
>> > >
>> > > This means that psql still does not work correctly. What it tries is
>> this:
>> > >
>> > > psql -p 5432 -d nominatim
>> > >
>> > > Sarah
>> > >
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/geocoding/attachments/20120913/d8f8441f/attachment.html>