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

Nyx nyxynyx at gmail.com
Wed Sep 12 21:51:05 BST 2012


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`.

However when I check the contents of the database `nominatim`, I still do
not see anything added to the table.

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/20120912/acfbd74f/attachment.html>


More information about the Geocoding mailing list