| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | kschindl <chuck666xx(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: listen_addresses = '*' postgresql 9.5 does not allow local connect |
| Date: | 2017-06-04 05:20:37 |
| Message-ID: | 16591.1496553637@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> writes:
> On Sat, Jun 3, 2017 at 8:51 PM, kschindl <chuck666xx(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | kschindl | 2017-06-04 05:37:56 | Re: listen_addresses = '*' postgresql 9.5 does not allow local connect |
| Previous Message | Scott Marlowe | 2017-06-04 05:01:13 | Re: listen_addresses = '*' postgresql 9.5 does not allow local connect |