Re: [ADMIN] Re: listen_addresses = '*' postgresql 9.5 does not allowlocal connect

On 6/3/17, 22:42, "pgsql-admin-owner@postgresql.org on behalf of kschindl" <pgsql-admin-owner@postgresql.org on behalf
ofchuck666xx@gmail.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