Re: Re: listen_addresses = '*' postgresql 9.5 does not allow local connect

On 6/3/17, 22:42, "pgsql-admin-owner(at)postgresql(dot)org on behalf of kschindl" <pgsql-admin-owner(at)postgresql(dot)org on behalf of chuck666xx(at)gmail(dot)com> wrote:

Tom Lane-2 wrote
I'd counsel looking into the postmaster log file. The described symptoms
sound like the postmaster is failing to start when given this setting,
and the log should offer some clue as to why.

I think we've seen similar reports that eventually traced to local DNS
misconfiguration, but that's theorizing in advance of the evidence.

regards, tom lane


thx.
That is what the log says:
2017-06-04 10:25:38 ICT [938-1] LOG: invalid connection type
"listen_addresses"
2017-06-04 10:25:38 ICT [938-2] CONTEXT: line 74 of configuration file
"/etc/postgresql/9.5/main/pg_hba.conf"
2017-06-04 10:25:38 ICT [938-3] FATAL: could not load pg_hba.conf

That is line 74
listen_addresses = '*'

copied from manual

so i am lost

The listen_addresses parameter goes in: postgresql.conf


doug