From: Tom Lane <tgl@sss.pgh.pa.us>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: kschindl <chuck666xx@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: listen_addresses = '*' postgresql 9.5 does not allow local connect
Date: Sun, 04 Jun 2017 01:20:37 -0400
Message-ID: <16591.1496553637@sss.pgh.pa.us> (raw)
In-Reply-To: <CAOR=d=1rj6fPgBLvDR+uVR0AzW92knufguzKNXyUFV1hwgyCeg@mail.gmail.com>
References: <1496544711321-5964669.post@n3.nabble.com>
<CAOR=d=1rj6fPgBLvDR+uVR0AzW92knufguzKNXyUFV1hwgyCeg@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, scott.marlowe@gmail.com, chuck666xx@gmail.com
Subject: Re: listen_addresses = '*' postgresql 9.5 does not allow local connect
In-Reply-To: <16591.1496553637@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox