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

Nyx nyxynyx at gmail.com
Wed Sep 12 14:34:15 BST 2012


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"
unable to start pgsql

----

I have already disabled open_basedir using WHM but is still getting this
error. I also see a database `nominatim` being created after running this
command, which I delete before retrying the import again. What should I try
next?



On Wed, Sep 12, 2012 at 8:54 AM, Frederik Ramm <frederik at remote.org> wrote:

> Hi,
>
>
> On 09/12/12 14:31, Nyx wrote:
>
>>      > Yup it does, doing `psql postgres` got me in:
>>      >
>>      > psql (9.1.5)
>>      > Type "help" for help.
>>      >
>>      > postgres=#
>>
>
> Actually, this will use the unix domain socket to connect, whereas PHP
> seems to have tried a TCP connection:
>
>
>       > > >         ["dsn"]=>
>>      > > >         array(9) {
>>      > > >           ["phptype"]=>
>>      > > >           string(5) "pgsql"
>>      > > >           ["dbsyntax"]=>
>>      > > >           string(5) "pgsql"
>>      > > >           ["username"]=>
>>      > > >           string(0) ""
>>      > > >           ["password"]=>
>>      > > >           bool(false)
>>      > > >           ["protocol"]=>
>>      > > >           string(3) "tcp"
>>      > > >           ["hostspec"]=>
>>      > > >           string(0) ""
>>      > > >           ["port"]=>
>>      > > >           bool(false)
>>      > > >           ["socket"]=>
>>      > > >           bool(false)
>>      > > >           ["database"]=>
>>      > > >           string(9) "nominatim"
>>      > > >         }
>>
>
> So, to properly simulate what PHP does you would have to try
>
> psql postgres -h localhost
>
> Bye
> Frederik
>
> --
> Frederik Ramm  ##  eMail frederik at remote.org  ##  N49°00'09" E008°23'33"
>
>
> ______________________________**_________________
> Geocoding mailing list
> Geocoding at openstreetmap.org
> http://lists.openstreetmap.**org/listinfo/geocoding<http://lists.openstreetmap.org/listinfo/geocoding>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/geocoding/attachments/20120912/161fb59a/attachment-0001.html>


More information about the Geocoding mailing list