Re: [ADMIN] listen_addresses = '*' postgresql 9.5 does not allow local connect - Mailing list pgsql-admin

From Tom Lane
Subject Re: [ADMIN] listen_addresses = '*' postgresql 9.5 does not allow local connect
Date
Msg-id 16591.1496553637@sss.pgh.pa.us
Whole thread Raw
In response to Re: [ADMIN] listen_addresses = '*' postgresql 9.5 does not allowlocal connect  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses [ADMIN] Re: listen_addresses = '*' postgresql 9.5 does not allow localconnect  (kschindl <chuck666xx@gmail.com>)
List pgsql-admin
Scott Marlowe <scott.marlowe@gmail.com> writes:
> On Sat, Jun 3, 2017 at 8:51 PM, kschindl <chuck666xx@gmail.com> wrote:
>> when i add the listen_addresses = '*' i cannot connect local (with or without
>> pgadmin)
>> as soon as i comment this out i can connect local where the server is
>> installed

> Is there another listen_addresses line in your conf file?

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


pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: [ADMIN] listen_addresses = '*' postgresql 9.5 does not allowlocal connect
Next
From: kschindl
Date:
Subject: [ADMIN] Re: listen_addresses = '*' postgresql 9.5 does not allow localconnect