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

[Sarah Hoffmann]

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