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

Frederik Ramm frederik at remote.org
Wed Sep 12 13:54:11 BST 2012


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"



More information about the Geocoding mailing list