Re: 9.4 on Ubuntu 15.04: ENETUNREACH error?

On 07/07/2015 11:21 PM, Chas. Munat wrote:
> I recently upgraded to Ubuntu 15.04 with PostgreSQL 9.4.4 with uuids and
> plv8 coffeescript extensions. I can access the database via psql. My web
> application uses node.js via pg-bricks. It works perfectly on my Mac dev
> machine.

The Mac has it's own database or is connecting to the one on the Ubuntu
machine?

>
> On the server, I get this error:
>
> preload failed { [Error: connect ENETUNREACH 127.0.0.0:5432 - Local
> (0.0.0.0:0)]
>    code: 'ENETUNREACH',
>    errno: 'ENETUNREACH',
>    syscall: 'connect',
>    address: '127.0.0.0',
>    port: 5432 }
>
> (Preload is a script in my app that does multiple queries via pg-bricks.)
>
> I have turned off ufw, set pg_hba.conf to TRUST, done everything I can
> think of -- no  joy.

Are you having IPv4/v6 issues?

Have you looked at/changed the settings for IPv6 connections in pg_hba.conf?

>
> Any ideas why this might be happening?
>


--
Adrian Klaver
adrian.klaver@aklaver.com